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

101 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
sultana725780(None) 
sultan63012591sultan_
sultanas8237151sultanas
sultans72411831sultans
saltant7316772saltant
subtaxa1644482subtaxa
suldan72611042suldan_
suldans8299722suldans
sultanate946052sultanate
sultanic1046172sultanic
suntan62613002suntan_
suntans72111732suntans
butane8313653bu_tane
dulciana1142573dulciana
exultant1545483exultant
guarana886303guarana
lantana739603lantana
liana53915893__liana
mustang10267933mustang
mutant8317693mu_tant
nutant6316383nu_tant
outland81212343outland
pulsant9310563pulsant
purana8712933pu_rana
resultant946443resultant
ruana5312423ru__ana
salina64221123sal_ina
saltine75018563saltine
salting84120793salting
saltpan935303saltpan_
saltpans1034813saltpans
sardana838643sardana
satang75711563s_atang
satara6315533s_atara
seitan62613233seitan_
seitans73312303seitans
sestina72711973sestina
sextan13389643sextan_
sextans14349263sextans
sextant142911963sextant
silane62718053sil_ane
silting83320483silting
silvan92810153silvan_
silvans10308333silvans
slang66324023s_l_ang
slank95822773s_l_ank
slant55238703s_l_ant
solan55328153sol_an_
soland75115043sol_and
solano65314183sol_ano
solans64122493sol_ans
solatia7312253solatia
soldan73511853soldan_
soldans83210403soldans
soutane7312063soutane
stand65923283s__tand
stane55933003s__tane
stang66424683s__tang
stank95823303s__tank
stanza1537073s__tanza
statant7313123statant
subpena1136673subpena
subtask1335713subtask
subtend1037103subtend
subtone9310343subtone
suiting83419003suiting
sulcal8311273sulca_l
sulcate9314423sulcate
sulfa8313923sul__fa
sulfas9311563sulfa_s
sulfate10311653sulfate
sulfone1037483sulfone
sulking124514313sulking
sullage859913sullage
sullen62914293sullen_
sulpha1135403sul_pha
sultanates1045233sultanates
sultaness945613sultaness
sultry938463sult_ry
summand1236263summand
sunland837473sunland
sunna55016063su__nna
surtax1337843surta_x
sustain738773sustain
sustains838553sustains
sutra54217933su_t_ra
sutta54015333su_t_ta
suttas63813793sutta_s
sylvan12257363sylvan_
sylvans13235893sylvans
tartana73010193tartana
tuatara745513tuatara
ulama7711473_ul_ama
ulan46527393_ul_an_
ulans54921303_ul_ans
ulna46317323_ul__na
ulpan7310123_ulpan_
ultima836313_ultima
ultra539363_ult_ra
yulan8411493yul_an_
yulans958673yul_ans

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.410435831.7
2DLD Change Limit1340271016.34321129.9
3Display Results1011010.0303366.7
 (SQL Overall)1786911016.78326343.9
 
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.