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 “laundry” 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.

107 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
laundry113351(None) 
foundry1433912foundry
gauntry1154112gauntry
lacunary13114152lacunary
launder8309142launder
launders9358742launders
maundy12506782maund_y
sundry1057942_sundry
andro6314163_a_ndro
angry9310863_a_ngry
augury10366663_augury
auntly95211063_auntly
aunty85919813_aun_ty
bandy114824183ba_nd_y
bawdry15516463ba_wdry
blandly1336043bla_ndly
boundary1444753boundary
canary11314693ca_nary
candy115119823ca_nd_y
cannery123610013cannery
cautery12349593cautery
country12388043country
dandy104416703da_nd_y
daubery13396213daubery
daubry12445483dau_bry
daunder9348893daunder
daunders10278473daunders
flaunty1354413flaun_ty
gantry103810113ga_ntry
gaudery1234743gaudery
gaudy106611463gau_d_y
gauntly1135333gauntly
handy125520873ha_nd_y
hungry1334973_hungry
jaunty16388513jaun_ty
kaury12429763kau__ry
lactary1237843lactary
lacunar9136293lacunar_
lacunars10114733lacunars
lady86527153la__d_y
lairdly1134913lairdly
laminary13337253laminary
land56337313la_nd__
landau7310613la_ndau
landed84619243la_nded
lander74028483la_nder
landers84026213la_nders
lands65426903la_nd_s
lanely93914483la_nely
laniary1068013laniary
lankly13439623la_nkly
lanky125517483la_n_ky
lanner64920603lanner_
lanners73618333lanners
lapidary1454093lapidary
lardy96119273la_rd_y
lathery133911123lathery
laud56527723lau_d__
lauded83812153lau_ded
lauder73815013lau_der
lauders84012893lauders
lauds65618483lau_d_s
launce8469183laun_ce
launces9329003launces
launch11368063laun_ch
laundered1185023laundered
launderer1094513launderer
laundress1042813laundress
laundries1045563laundries
laundryman1651383laundryman
laundrymen1651413laundrymen
laura54116203lau__ra
lawny115912013lawn__y
legendry1342493legendry
lindy96918313l_ind_y
loudly1037783lou_dly
loungy10476833loun_gy
loury85716753lou__ry
lunacy1136843l_unacy
lunar57017313l_unar_
lunars65012813l_unars
luny77324133l_un__y
luxury1642543l_uxury
manuary1237773manuary
maund85515453maund__
maunder10328683maunder
maunders11348343maunders
maunds9519653maund_s
pandy115021173pa_nd_y
panfry14456413pa_nfry
pantry115014103pa_ntry
paunchy17324443paunchy
quandary2143433quandary
randy95022083ra_nd_y
raunchy15284313raunchy
roundly1136723roundly
sandy94221133sa_nd_y
saury84317223sau__ry
soundly1136683soundly
tannery10388663tannery
tawdry13395253ta_wdry
thundery1533823thundery
tundra736423_tundra
unary8315993__unary
undy85015163__und_y
updry1135483__updry
vaunty12409063vaun_ty

Search took 7 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 Filter1786911340270.406440125.6
2DLD Change Limit1340271076.25021444.3
3Display Results1071070.0462326.1
 (SQL Overall)1786911076.70226662.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.