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

253 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
saltant731677(None) 
alant55742292_al_ant
aslant6317752asl_ant
blatant9310672blatant
callant94121222callant
gallant83517112gallant
natant6318732na_tant
salient7419762salient
saltest71916512saltest
saltine75018562saltine
salting84120792salting
saltpan935302saltpan_
saltpans1034812saltpans
satang75711562sa_tang
savant9416042sa_vant
sealant73118302seal_ant
sextant142911962sextant
slant55238702s_l_ant
statant7313122statant
sultan63012592sultan_
sultana7257802sultana
sultans72411832sultans
valiant10314622valiant
alan46844083_al_an_
aland65526413_al_and
alane56135613_al_ane
alang66023513_al_ang
alans55636173_al_ans
alants67722023_al_ants
alkane104313323_alkane
alkanet113714433_alkanet
altar55520643_alta_r
altars64518153_altars
alterant8614963_alterant
arrant6623253_arrant
askant10412713_askant
attaint7313473_attaint
attent62818323_attent
avant86224663_a_vant
ballast9313993ballast
caftan111710123caftan_
caftans12179443caftans
callan83619603callan_
callans94518473callans
callants104112143callants
captan101613343captan_
captans111612053captans
castanet10416193castanet
clamant11312433clamant
dalton7311273dalton_
daltons8310403daltons
dilatant948203dilatant
distant83519953distant
eluant6315093_eluant
extant132714753_extant
exultant1545483exultant
fantast10311703fantast
galavant1246353galavant
galivant1247083galivant
gallants93310373gallants
gardant9314463gardant
gelant72821673gel_ant
gellant83214053gellant
habitant1348673habitant
halting114419073halting
instant7815353instant
kaftan13185823kaftan_
kaftans14185353kaftans
kalian10312163kalian_
kalians11310183kalians
lallan63414183lallan_
lalland83810193lalland
lallans74113543lallans
lantana739603lantana
latent64124303la_tent
leant56737783__leant
maltase938903maltase
malting103219083malting
militant10411403militant
mutant8317693_mutant
nutant6316383_nutant
octant81216553_octant
oscitant1046903oscitant
pageant10312783pageant
palpitant1345313palpitant
partan83820563partan_
partans94418283partans
passant9813943passant
patent84524923pa_tent
peltast9310513peltast
plant75437113_pl_ant
platan83913693platan_
platane93112303platane
platans93413123platans
pliant83918823_pliant
pulsant9310563pulsant
radiant82817133radiant
rampant11312173rampant
ratan53722663ra_tan_
ratans63819373ra_tans
ratany93411873ra_tany
rattan63613603rattan_
rattans73411953rattans
reactant10311433reactant
reliant7319243reliant
reptant92817073reptant
resultant946443resultant
sabbat10314713sabba_t
saint55147073sa__int
salaam8711013sal_aam
salaams997703salaams
salad65321833sal_a_d
saladang1043843saladang
salads75316963sal_ads
salal55425703sal_a_l
salals65120083sal_als
salami8313103sal_ami
salary9515213sal_ary
salients839563salients
salina64221123sal_ina
salinas73116093salinas
saline65132703sal_ine
sallet63734543sal_let
salmon84614183salmon_
salmons93713263salmons
salon55228553sal_on_
salons63823693sal_ons
saloon64418023saloon_
saloons74415323saloons
salpa75018353salpa__
salpae84614273salpa_e
salpas85116923salpa_s
salpian938493salpian_
salpians1036763salpians
salpinx1636093salpinx
salsa56718923salsa__
salsas65316133salsa_s
salt45758523sal___t
saltbox1643743saltbox
salted74121203salt_ed
salter64325083salt_er
saltern74010653saltern
salterns8388903salterns
salters73622253salters
saltie63422433salt_ie
saltier74318633saltier
salties73725773salties
saltiest83117723saltiest
saltily10310543saltily
saltines82917793saltines
saltings92811253saltings
saltire73113043saltire
saltish10312163saltish
salts55431883salt__s
saltwort1148603saltwort
salty85524383salt__y
salutary1145113salutary
saluting9310553saluting
salvage1138193salvage
salving113913153salving
sampan102511893sampan_
sampans112411003sampans
sapient9415343sapient
saran53730303sa_ran_
sarans64224433sa_rans
sardana838643sardana
sarment9318763sarment
satangs8479713sa_tangs
satanic939933sa_tanic
satanist8313373sa_tanist
satara6315533sa_tara
satay84718463sa_ta_y
satays94411683sa_tays
satin55935223sa_tin_
satinet7325283sa_tinet
sating74735453sa_ting
satins64930483sa_tins
satiny93817983sa_tiny
saturant8410643saturant
savants1038653sa_vants
scant79735073s__cant
sealants82610743seal_ants
seawant103613413seawant
secant84023293s_ecant
seitan62613233seitan_
seitans73312303seitans
sejant133114483s_ejant
sejeant1489723sejeant
servant10313633servant
sextan13389643sextan_
sextans14349273sextans
sextants15287383sextants
shaitan1036893shaitan_
shaitans1136413shaitans
silane62718053sil_ane
silent64125843sil_ent
silting83320483silting
silvan92810153silvan_
silvans10308333silvans
sklent103614353skl_ent
slang66324023s_l_ang
slank95822773s_l_ank
slants64819083s_l_ants
slanty95114843s_l_anty
slat46959023s_l_a_t
slating83724653slating
smaltine1037833smaltine
solan55328153sol_an_
soland75115043sol_and
solano65314183sol_ano
solans64122493sol_ans
soldan73511853soldan_
soldans83210403soldans
solvent10310833solvent
sonant6621953s_onant
soutane7312063soutane
spartan948333spartan_
spirant9814293spirant
splat76129343spl_a_t
splent84720193spl_ent
splint85223283spl_int
stagnant946893stagnant
stalwart1147193stalwart
stand65923283s__tand
stane55933003s__tane
stang66424693s__tang
stank95823303s__tank
start55642313s__tart
stat47352693s__ta_t
stent55634513s__tent
stint57037663s__tint
stunt55328173s__tunt
suldan72611043suldan_
suldans8299723suldans
sultanas8237153sultanas
sultanate946053sultanate
sultanic1046173sultanic
suntan62613003suntan_
suntans72111733suntans
sylvan12257363sylvan_
sylvans13235893sylvans
taggant9310223taggant
talent6323323tal_ent
tartan64217513tartan_
tartana73010193tartana
tartans72615823tartans
vacant11415133va_cant
vagrant11410663vagrant
valiants1137793valiants
variant10316803variant
volant9316323vol_ant
volitant1147863volitant
warrant10614243warrant

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.406440125.6
2DLD Change Limit1340272536.64020184.8
3Display Results2532530.0932720.4
 (SQL Overall)1786912537.13925030.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.