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 “tardo” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

99 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
tardo6532110(None) 
tardy94720461tardy
taro46846911tar_o
ado49146872_a_do
arco68331542_arco
ardor64617862_ardor
arvo76023432_arvo
bard75648862bard_
barde85330772barde
bards87139642bards
carbo94923842carbo
card710245872card_
cardio9915672cardio
cardon94120852cardon
cards85137932cards
cargo85322072cargo
dado67126332da_do
fado87226462fa_do
fard85639062fard_
fards96629842fards
faro76136922far_o
fordo97218652fordo
garda7316762garda
hairdo1036432hairdo
hard85443502hard_
hards96435652hards
hardy125622062hardy
karoo92519582karoo
lard56742002lard_
lardon74415062lardon
lards65331862lards
lardy96119272lardy
largo65319782largo
narco76718242narco
nard56634452nard_
nards65928462nards
ordo54622352_ordo
pard76441322pard_
pardi85723952pardi
pardon94618732pardon
pards85634332pards
pardy115523952pardy
pareo74632602pareo
pargo86723722pargo
parvo107719182parvo
sard55344242sard_
sards64736182sards
sargo65424412sargo
sarod65325872sarod
stardom1037762stardom
taboo73418092taboo
taco67031352ta_co
tad47959822ta_d_
tads57143942ta_ds
tango66921192tango
tanto55724952tanto
tao38358952ta__o
tar37570692tar__
tardyon1134672tardyon
tare45957622tar_e
tared69340052tared
tares57456562tares
targe65227102targe
tarn46842722tar_n
tarns56433952tarns
taroc75721642taroc
tarok97921072tarok
taros55640822taros
tarot55943932tarot
tarp66936422tar_p
tarpon82812802tarpon
tarps76527122tarps
tarre55825632tarre
tarry85422512tarry
tars46763952tar_s
tarsi55222172tarsi
tart47566182tar_t
tarts57242022tarts
tarty86328182tarty
teredo7310782teredo
thro77726422thr_o
tiro46832362tir_o
tondo69718682tondo
toro48045682tor_o
torso56922142torso
trad55630912trad_
trade65026042trade
trio45233342t_rio
trod57627952t_rod
tsardom1044482tsardom
turbo71015042turbo
turd56027622turd_
turds65021692turds
tyro76622362tyr_o
tzardom1943732tzardom
ward86542252ward_
wards97734402wards
yard85633252yard_
yards95324612yards

Search took 2 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 Filter178691538000.326548131.9
2DLD Change Limit53800991.59333772.8
3Display Results99990.0333000.0
 (SQL Overall)178691991.95291542.5
 
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.