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

122 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
foundry143391(None) 
boundary1444752boundary
country12388042country
fondly13299042fo_ndly
found94917842found__
founded124011422founded
founder114312572founder
founders123911672founders
founds104814192found_s
laundry1133512laundry
roundly1136722roundly
soundly1136682soundly
sundry1057942_sundry
bouldery14295013bouldery
bouncy13409073boun_cy
bound84819583bound__
bounded113613763bounded
bounden10389453bounden
bounder104215533bounder
bounders114314113bounders
bounds94415803bound_s
bounty113411073boun_ty
county114313323coun_ty
fernery1335813fernery
feudary1444273feudary
finery124512893f_inery
flouncy1543673floun_cy
flounder1235103flounder
flounders1374613flounders
floury12449573flou__ry
fluidly1434813fluidly
flunkey17405793flunkey
flunky16408093flun_ky
flurry12397113flu_rry
fond86330953fo_nd__
fonded115717043fo_nded
fonder104120063fo_nder
fondle104412943fo_ndle
fonds95824823fo_nd_s
fondu96013973fo_nd_u
fondue104510493fo_ndue
fondus105210943fo_ndus
foolery1336693foolery
foppery17385623foppery
forgery14419303forgery
foulard11257283foulard
fouler93614903fouler_
foully1239013fou_lly
foundered1435403foundered
founding133010793founding
foundries1345693foundries
fount84727033foun__t
founts94313383foun_ts
four76226863fou__r_
fours85521493fou__rs
fuddy135211153f_u_ddy
fund85624983f_und__
funded114413893f_unded
funder104016083f_under
funders113813933f_unders
fundi96814913f_und_i
fundic12389083f_undic
funds94119253f_und_s
fundus10429173f_undus
funky154315133f_un_ky
funny114614833f_un_ny
furry116719283f_u_rry
fury107727973f_u__ry
gauntry1154113gauntry
hound95016483hound__
hounded123311033hounded
hounder113412233hounder
hounders123111713hounders
hounds104413133hound_s
hungry1334973_hungry
jocundly2142213jocundly
joinery17366593joinery
jouncy18336203joun_cy
loudly1037783lou_dly
loungy10476833loun_gy
loury85716753lou__ry
maundy12506783maund_y
monandry1443233monandry
mouldy12437413mould_y
mound83918313mound__
mounded113711983mounded
mounds93915133mound_s
noonday1144603noonday
onery8414123_o_nery
ornery938463_ornery
outcry1137993_outcry
poultry1235383poultry
pound84417863pound__
poundal1036403poundal
pounded114112793pounded
pounder103314003pounder
pounders113113283pounders
pounds93714383pound_s
rotundly1243433rotundly
roughdry1692543roughdry
round64318433round__
rounded93013503rounded
roundel8308853roundel
rounder83514603rounder
rounders92613693rounders
rounds73615623round_s
roundup1044063roundup
sound64420023sound__
sounded93214463sounded
sounder83315383sounder
sounders93214113sounders
sounds74616183sound_s
thundery1533823thundery
tundra736423_tundra
unary8315993__unary
undy85015163__und_y
updry1135483__updry
wound94414213wound__
wounded12329763wounded
wounds103811633wound_s
zonary1838793zo_nary
zounds164310173zound_s

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 Filter1786911340270.423422437.4
2DLD Change Limit1340271226.78319759.3
3Display Results1221220.0462652.2
 (SQL Overall)1786911227.25224640.2
 
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.