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

262 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
extant13271475(None) 
extent132714911extent
sextant142911961sextant
eluant6315092eluant
entrant7318872entrant
errant6618732errant
exact143516932ex_act
exalt123018532ex_alt
excitant1777352excitant
exeunt1338702exeunt
expand16236572expand
expat14313812expa_t
explant16310132explant
extend14267522extend
extents142610172extents
extinct1646892extinct
extort13513972extort
extract16311012extract
extranet15412992extranet
exultant1545482exultant
mutant8317692mutant
natant6318732natant
nutant6316382nutant
octant81216552octant
reptant92817072reptant
sextan13389642sextan_
sextans14349262sextans
sextants15287382sextants
alant55742293_alant
ant37270793___ant
arrant6623253arrant
askant10412713askant
aslant6317753aslant
attaint7313473attaint
attent62818323attent
avant86224663_avant
axman144813183axman_
bezant17814543bezant
bezzant1746893bezzant
blatant9310673blatant
botany1139263botany
brant74742173_brant
butane8313653butane
byzant2096813byzant
cant66362033__cant
cetane8315283cetane
chant105932693_chant
cotan71521783cotan_
cotans81317923cotans
debutant1146183debutant
decant93524223decant
defiant11311923defiant
descant104315583descant
detent73624483detent
deviant11311313deviant
dextran1586163dextran_
dextrans1695983dextrans
distant83519953distant
dopant9316133dopant
east46659103e__ast
eat36989053e__a_t
eaten55323053eaten_
eating75134403eating
eclat7523603ecla_t
elan46734243e_lan_
eland65820393e_land
elans55527753e_lans
elegant8311503elegant
elint55436473e_lint
eluants737583eluants
eluent6315483eluent
emanant9411083emanant
embank14346553embank
enact73525363e_nact
enchant12313113enchant
enrapt8313013enrapt
entail61114343entail
entente7412953entente
entrants8311753entrants
epact94921533e_pact
equitant1746923equitant
errand758793errand
errants7410643errants
estate64719763estate
eta35834193e_ta__
etape74413703e_tape
etas46432273e_ta_s
etchant1249813etchant
ethane94613243ethane
etna46415263e_t_na
etnas54713933e_tnas
eutaxy1643303eutaxy
event85924443e_vent
exacta15337393ex_acta
exacts15359613ex_acts
exalts13328313ex_alts
exam132514623ex_a_m
exams14199083ex_ams
except1797653except
excitants1864393excitants
executant1844113executant
exempt1737453exempt
exert124624143ex_ert
exhalant1895353exhalant
exhale1636873exhale
exhalent1865573exhalent
exhaust1744243exhaust
exhort16410803exhort
exigent1539513exigent
exine125518493ex_ine
exing136016813ex_ing
exist124618943ex_ist
existent1548263existent
exit114428673ex__it
exiting15311393exiting
exon117116803ex_on_
exons125813343ex_ons
expands17195733expands
expanse16145603expanse
expats1537683expats
expect1758903expect
expectant2045673expectant
expend16247503expend
expert15515353expert
explants1737023explants
export15412183export
exsecant1794753exsecant
exsect1558503exsect
exsert13414363exsert
extends15227113extends
extern1348473extern
externe1438573externe
externs1438233externs
extincts1743473extincts
extol1247893ext_ol
extoll1334863extoll
extols1337683extols
extorts1447753extorts
extra1239003ext_ra
extracts1747623extracts
extranets1646363extranets
extras13310223extras
exult122814123ex_ult
gelant72821673gelant
gellant83214053gellant
gestalt8411163gestalt
giant65430593_giant
gitano738043gitano
grant64840023_grant
hant75461593__hant
heptane1238363heptane
hesitant1149083hesitant
hexane16379533hex_ane
incant82418503incant
infant92315133infant
instant7815343instant
intact8314663intact
intent63122773intent
intrant7318753intrant
jessant1438443jessant
jurant134216553jurant
latent64124303latent
leant56737783_leant
levant9314493levant
litany939053litany
meant76537213_meant
mediant103516703mediant
mutants938583mutants
nonextant1646203nonextant
octan71313483octan_
octane81411633octane
octans81411143octans
octants9128733octants
outact8317203outact
oxcart1539523oxcart
oxidant1547363oxidant
oxtail1337653oxtail
pant66061263__pant
patent84524923patent
peasant9314923peasant
peccant13311733peccant
pedant9319493pedant
peltast9310513peltast
pendant10314853pendant
pennant9312493pennant
pentane9415743pentane
plant75437113_plant
pliant83918823pliant
potent84223353potent
quant143624813_quant
rant45864683__rant
ratan53722663ratan_
ratans63819373ratans
ratany93411873ratany
reactant10311433reactant
reboant9315093reboant
recant83228683recant
regnant8312843regnant
regrant8317323regrant
reliant7319243reliant
remnant9312633remnant
replant93318533replant
restart7320033restart
retint65633443retint
riant55833153_riant
saltant7316773saltant
satang75711563satang
savant9416043savant
scant79735073_scant
sealant73118303sealant
seawant103613413seawant
secant84023293secant
seitan62613233seitan_
seitans73312303seitans
sejant133114483sejant
sejeant1489723sejeant
servant10313623servant
sextain14257103sextain
sextains15246813sextains
sextet13916873sext_et
sexton133610793sexton_
sextons143710413sextons
slant55238703_slant
sonant6621953sonant
stand65923283_stand
stane55933003_stane
stang66424683_stang
stank95823303_stank
start55642313_start
stat47352693_sta_t
statant7313123statant
stent55634513_stent
stint57037663_stint
stunt55328173_stunt
tact67349033__tact
taint55542283__taint
tan37167573__tan_
tang56138673__tang
tank85134023__tank
tans46154823__tans
tanto55724943__tanto
tart47566183__tart
tat37690293__ta_t
taunt55532283__taunt
taut47048963__taut
tenant6322473tenant
tent46159863__tent
tetany959843tetany
tint46758863__tint
titan53318173titan_
titans63414913titans
titrant7315193titrant
truant6315783truant
tyrant9315333tyrant
vacant11415133vacant
vegetant1246963vegetant
verdant11313293verdant
versant10313833versant
volant9316323volant
want76156173__want
witan83816503witan_
witans93412933witans

Search took 6 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 Filter1786911127160.406440125.6
2DLD Change Limit1127162624.73323814.9
3Display Results2622620.0803275.0
 (SQL Overall)1786912625.21934238.6
 
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.