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

243 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
destain841208(None) 
destains9311811destains
detain74617381de_tain
distain8313781distain
abstain947252abstain
certain92612212certain
deltaic1037022deltaic
dentin73919572dent_in
desman9311692desma_n
despair1045462despair
destained1158252destained
destine83719952dest_ine
destiny113111462dest_iny
detail74516432de_tail
detains83716092de_tains
detrain8412252detrain
dextrin1587532dextrin
disdain938512disdain
distains9413602distains
distrain9412242distrain
dustbin1044542dustbin
estrin6315922_estrin
oestrin7312232oestrin
pertain92714962pertain
restrain8311702restrain
retain64523282re_tain
sextain14257092sextain
stain55727932__stain
sustain738762sustain
abstains1047323abstains
attain6311753_attain
bestial9311643bestial
besting104923923best_ing
bestir8311163best_ir
bestrid1039973bestrid
betaine9413783be_taine
captain112111053captain
centai84814783centai_
ceratin93020163ceratin
cesta75419483cesta__
cestas85018543cesta_s
cesti75217423cest_i_
cestoi84511953cestoi_
cestoid104011673cestoid
contain9315823contain
curtain9319793curtain
cystein1246053cystein
dastard9279703dastard
deair65817193de__air
dean56039483de__a_n
debating123213733debating
declaim1247363declaim
deewan10267553deewa_n
deistic10311173deist_ic
delaine8314783de_laine
delating103119603delating
delation92318083delation
delta66117773delta__
deltas74414823delta_s
deltic9312503delt_ic
deltoid938563deltoid
demean9510563demea_n
dental74319173denta_l
dentalia947523dentalia
dentals83915393dentals
dentate8315153dentate
dentation10315233dentation
dentil74017883dent_il
dentine83320243dent_ine
denting94422183dent_ing
dentins83419223dent_ins
dentoid9310663dentoid
depaint10314593de_paint
deraign936573de_raign
derail74218813de_rail
derating103222273derating
desalt7518313des_alt
desand84812633des_and
descant104315583descant
desexing1736293desexing
design8408933des_ign
desiring10312143desiring
deskman1444323deskman
deskmen1435023deskmen
desmans1039003desmans
desmid1048363des_mid
desmoid1137103desmoid
despairs1144943despairs
despoil1046523despoil
destaining1267943destaining
destined103312453dest_ined
destines93619663dest_ines
destining11311433destining
destrier9311823destrier
destroy1138153destroy
detach12310413de_tach
details84214043de_tails
detained103111643de_tained
detainee92511723de_tainee
detainer92910793de_tainer
detrains9411753detrains
deutzia1743123deutzia
devein1039143de_vein
dewan95718043de_wa_n
dextran1586163dextran
dextrine1688253dextrine
dextrins16117823dextrins
disdains1037913disdains
disjoin1547643disjoin
distaff1467673distaff
distained1139593distained
distal73615763dista_l
distant83519953distant
distil73616433dist_il
distrains10411333distrains
distraint101112903distraint
distrait9414343distrait
doeskin1245153does_kin
domain9511323d_omain
drain65222893d__rain
dustbins1144593dustbins
dusting93618993dust_ing
dustman1044683dustman
dustmen1035773dustmen
dustpan1043243dustpan
dystaxia19123453dystaxia
elain55324703_e_lain
entail61114343_entail
entrain7313073_entrain
essoin638193_essoin
estate64719763_estate
estating92614993_estating
estrins7315853_estrins
etamin81311853_e_tamin
eyestrain1243433eyestrain
festal94213563festa_l
festoon1037673festoon
fusain958643fus_ain
fustian1036903fustian
gastrin839823gastrin
gelatin83514733gelatin
gentian8310103gentian
gestalt8411163gestalt
gestapo1044493gestapo
gestate83614073gestate
gestating11229983gestating
gestation10310663gestation
gestic9312773gest_ic
hematin121516013hematin
hessian1035853hessian
histamin1387023histamin
isatin6412213_isatin
jesting154317713jest_ing
keratin113314153keratin
lectin82515013lect_in
leptin82512333lept_in
lesbian944463lesbian
mesian84315503mesia_n
messan83912063messa_n
mestino9411643mest_ino
mislain9311243mislain
mistrain10311943mistrain
nesting84320443nest_ing
nestling958893nestling
nystatin1145093nystatin
obtain839183_obtain
oestrins8312673oestrins
pectin102615533pect_in
pertains102113413pertains
pestling111010253pestling
petsai838083petsai_
petsais938433petsais
postin83521033post_in
reattain846733reattain
redtail858713redtail
refrain10310043refrain
regain74517763re_gain
remain85919863re_main
reobtain1044623reobtain
resaid74517083res_aid
resail64418733res_ail
resawn9399953res_awn
resilin72913973resilin
resin54131053res__in
restack1339433restack
restaff1339003restaff
restage83316183restage
restaging112410853restaging
restamp1146483restamp
restart7320033restart
restate73824873restate
restating102319413restating
restation9316913restation
resting85031183rest_ing
restrains9311623restrains
restraint9412753restraint
restring91518783restring
retail65522073re_tail
retains74522253re_tains
retrain7615423retrain
sain45551293__s_ain
satin55935213__satin
seatrain847923seatrain
seitan62613233seita_n
sestina72711973sest_ina
sestine73017923sest_ine
sextains15246813sextains
sextan13389643sexta_n
slain54923573__slain
staid66722073__staid
staig65519633__staig
stains64923653__stains
stair54719933__stair
statin63921463__statin
stein54620533__stein
strain64919573__strain
sustains838553sustains
swain84919053__swain
tain45548073___tain
tearstain943433tearstain
terrain7410833terrain
tertian7511193tertian
testa54822043testa__
testacy1235963testacy
testae64216253testa_e
testate73916233testate
testing86021053test_ing
testis64916713test_is
teston6313303test_on
testoon748363testoon
upstair943983upstair
ventail10310453ventail
vervain1335563vervain
vesta86618303vesta__
vestal94615573vesta_l
vestals104612333vestals
vestas95916683vesta_s
vesting114618683vest_ing
western102911093western
westing115020273west_ing
yestern10338633yestern
zeatin15412823zeat_in
zesting174515333zest_ing

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340272437.84617082.2
3Display Results2432430.0902700.0
 (SQL Overall)1786912438.09222082.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.