Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “laundered” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

106 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
laundered118502(None) 
daundered1294421daundered
launderer1094511launderer
maundered1394941maundered
blundered1335202blundered
dandered112110962da_ndered
floundered1542422floundered
foundered1435402foundered
gandered112211172ga_ndered
glandered1236342gla_ndered
laddered1136742la_ddered
launder8309152launder__
launderers1183872launderers
launders9358752launder_s
lavendered1541942lavendered
maunderer1294192maunderer
pandered121812572pa_ndered
plundered1344322plundered
relaundered1352042relaundered
sauntered1036292sauntered
slandered1137472sla_ndered
sundered10312152_sundered
thundered1444572thundered
unlaundered1351942unlaundered
wandered132110792wa_ndered
angered93013473_a_ngered
bannered11299323ba_nnered
bantered113313653ba_ntered
blunderer1244553blunderer
bouldered1344483bouldered
bunkered15177183_bunkered
calendered1443393calendered
cancered132411553ca_ncered
cankered153010223ca_nkered
cantered113415993ca_ntered
chuntered1536663chuntered
cindered1239793_cindered
countered12313003countered
dangered11248513da_ngered
daunder9348903daunder__
daunders10278483daunder_s
fendered13258673_fendered
garnered10247123garn_ered
gauffered1741873gauffered
gendered11258873_gendered
hankered16289443ha_nkered
hindered1339453_hindered
hundred1237143_hund_red
hungered13217053_hungered
hunkered16186923_hunkered
jaundiced2041193jaundiced
juddered1833583_juddered
laagered1055853la_agered
lackered15108683la_ckered
lacquered2143373lacquered
ladened979053la__dened
lagered92311153la__gered
lanceted1137083la_nceted
landed84619243la_nd__ed
lander74028493la_nder__
landers84026223la_nder_s
lanneret82512363la_nneret
lappered13288213la_ppered
lathered121512333la_thered
lauded83812153lau_d__ed
lauder73815013lau_der__
lauders84012893lau_der_s
launched1475403laun_ched
launderette1251823launderette
laundering1245183laundering
laundress1042813laundress
laundries1045563laundries
laundry1133513laund_r_y
laureled934543lau_reled
laveered1235253la_veered
lawyered1534033la_wyered
layered11259413la__yered
lingered10129643l_ingered
loudened1044693lou_dened
louvered1244993lou_vered
lumbered13188233l_umbered
lustered92510613l_ustered
mannered11249653ma_nnered
maunder10328693maunder__
maunderers1383753maunderers
maunders11348353maunder_s
meandered1346143meandered
mouldered1343753mouldered
murdered1236033_murdered
panderer112210913pa_nderer
panniered1243853panniered
paupered13216943pau_pered
plunderer1243763plunderer
pondered126411293_pondered
rendered102512263_rendered
saunterer945033saunterer
scunnered1243803scunnered
shuddered1543433shuddered
slanderer1046673sla_nderer
squandered2142723squandered
sunderer9310523_sunderer
tendered102510603_tendered
thunderer1344253thunderer
underfed13311713__underfed
wanderer122210123wa_nderer
wondered13239943_wondered

Search took 8 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911486410.436409841.7
2DLD Change Limit1486411067.48619855.9
3Display Results1061060.0432465.1
 (SQL Overall)1786911067.96522434.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.