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

126 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
lardoons939848(None) 
cardoons113411941cardoons
lardons83914491lard_ons
lardoon83410371lardoon_
bradoons1136762bradoons
cardons104519942card_ons
cardoon104813812cardoon_
cartoons104012802cartoons
gadroons1037012gadroons
harpoons1337482harpoons
jargoons1644662jargoons
ladrons83813192la_drons
lagoons839252la_goons
lampoons12266872lampoons
lardon74415062lard_on_
maroons92615552mar_oons
pardons103817622pard_ons
tardyons1244612tardyons
adorns74212613_a_dorns
archons12311583_archons
ardors74416873_ard_ors
ardours8368883_ardours
arduous837613_arduous
argons75018203_ar_gons
arsons63917213_ar_sons
baboons113211083ba_boons
balloons103110523balloons
barons85025383bar__ons
barrooms1237893barrooms
baryons121010473bar_yons
barytons1345573barytons
bassoons1036553bassoons
baudrons1135763baudrons
bradoon1037353bradoon_
bridoons1145423bridoons
caldrons1138063caldrons
carbons115418943car_bons
cardamons1445203cardamons
cardon94120853card_on_
carpools1237883carpools
carrions10312453carrions
carryons1337103carryons
cartons94122473car_tons
cartoon94114463cartoon_
cartoony13377403cartoony
clarions10310493clar_ions
cordons104415763cord_ons
croons85418423_cr_oons
dahoons1137753da_hoons
dragoons1045013dragoons
eardrops1165303eardrops
gaboons10289903ga_boons
gadroon938173gadroon_
galloons9289703galloons
garcons102411643gar_cons
gardens93312093gard_ens
garrons82713463gar_rons
godroons1045363godroons
hadrons113314303ha_drons
hagdons1258523hagd_ons
hardboots1544353hardboots
hardens113815023hard_ens
hardgoods15153653hardgoods
hardpans1436453hardpans
hardtops1444843hardtops
hardwoods17135513hardwoods
harpoon1238313harpoon_
jargons1558203jar_gons
jargoon1545193jargoon_
karoos102415803kar_oo_s
karroos1139313karroo_s
kroons103711243_kr_oons
ladens74516233la_d_ens
ladhoods1345873ladhoods
ladinos8389963la_dinos
ladron73413323la_dron_
ladrone83611873la_drone
ladrones92710973ladrones
lagoon7410483la_goon_
lampions12277973lampions
lampoon11267193lampoon_
lapdogs1134073lapd_ogs
larders83516943lard_ers
larding92917873lard_ing
lards65331863lard___s
largos74815063lar_go_s
lawbooks1743743lawbooks
letdowns1243483letdowns
loons55731723l___oons
lordomas1145083lordomas
lordoses937143lordoses
lordosis944453lordosis
lorgnons943993lorgnons
lowdowns1543463lowdowns
lurdans837073lurd_ans
lyricons1343583lyricons
madronos11337543madronos
madzoons20124773madzoons
markdowns1942463markdowns
maroon83118203mar_oon_
marrons93216973mar_rons
matzoons19105083matzoons
pandoors11258983pandoors
paragons11311503paragons
pardon94618733pard_on_
parodos103011753parodo_s
parsons93516873par_sons
partons94620513par_tons
patroons102710603patroons
platoons1038683pla_toons
playdowns1843073playdowns
quadroons1944183quadroons
raccoons1265453raccoons
racoons93912433ra_coons
radons74118533ra_d_ons
ratoons73815473ra_toons
rattoons8327513rattoons
saloons74415323sa_loons
tandoors9258053tandoors
tardyon1134673tardyon_
tarpons92612213tar_pons
teardowns1343043teardowns
varooms1248883var_ooms
wardens113711903ward_ens
wardrooms1544183wardrooms
warisons1136903warisons

Search took 9 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 Filter1786911461620.420425454.8
2DLD Change Limit1461621267.73618893.7
3Display Results1261260.0462739.1
 (SQL Overall)1786911268.20221786.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.