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

134 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
sextains1524681(None) 
sextain14257101sextain_
sextans14349261sexta_ns
destains9311812destains
detains83716092de_tains
dextrins16117822dextrins
pertains102113422pertains
retains74522252re_tains
seatrains947602seatrains
seitans73312302seita_ns
sextan13389642sexta_n_
sextant142911962sexta_nt
sextants15287382sextants
sextarius1644212sextarius
sextons143710412sext_ons
stains64923652s__tains
sustains838552sustains
abstains1047323abstains
ascertains1244263ascertains
attains7310983_attains
betaine9413783be_taine
betaines10313293be_taines
captains121810573captains
ceratins102818733ceratins
certain92612213certain_
contains10316533contains
curtains10259703curtains
dentins83419223dent_ins
destain8412083destain_
details84214043de_tails
detain74617383de_tain_
detrains9411763detrains
dextrans1695983dextrans
dextrin1587543dextrin_
dextrine1688253dextrine
dextrines1798313dextrines
distains9413603distains
elains64919853_e_lains
entails7912823_entails
entrains8312963_entrains
estrins7315853_estrins
etamins91511833_e_tamins
explains1766443_explains
extant132714753_exta_nt
externs1438233_externs
foxtails1844583foxtails
gelatins93414093gelatins
gentians937563gentians
hematins131714683hematins
keratins122313483keratins
lectins92515003lect_ins
leptins92412693lept_ins
obtains939163_obtains
oestrins8312673oestrins
oxtails1436383_oxtails
pectins112315233pect_ins
pertain92714963pertain_
reattains946443reattains
redtails968003redtails
refrains1139593refrains
regains84316583re_gains
remains94117903re_mains
reobtains1144433reobtains
restrains9311623restrains
retails74718973re_tails
retain64523283re_tain_
retrains8314533retrains
sains55639973s___ains
satins64930483s_at_ins
seating84130683seat_ing
seatings93614303seat_ings
seatrain847923seatrain_
seawans10379943seawa_ns
sectarians1245833sectarians
sectaries11312243sectaries
sections102714703sections
sedans74816093se_da_ns
sedating103014113sedating
sedations10311253sedations
seething1239023seething
seisins73614393se_isins
seitan62613233seita_n_
seizins164010133se_izins
sentries81318053sentries
septages1168263septages
septics112810433sept_ics
sequins1637863se_quins
serails73318363se_rails
serais64326133se_rai_s
sereins73716113se_reins
sericins10312463sericins
serins64029673se__rins
sestina72711973sest_ina
sestinas8249133sest_inas
sestine73017923sest_ine
sestines82717243sest_ines
setline7313923se_tline
setlines8312743se_tlines
setons64620173se_t_ons
setting83621393se_tting
settings93810073se_ttings
settling978943settling
settlings1054683settlings
sewans95215903se_wa_ns
sexing144313893sex__ing
sextarii1543183sextarii
sextets1497143sext_ets
sextile1438573sext_ile
sextiles1537643sextiles
sexton133610793sext_on_
sextos134012163sext__os
sexts125118383sext___s
sheitans1155603sheita_ns
sixteens1542943sixteens
sixties14310973sixt_ies
sprains93013593s_prains
staigs75414813s__taigs
stain55727943s__tain_
stairs65416333s__tairs
statins73719773s__tatins
steins64818343s__teins
stotins73213873stot_ins
strains74218153s_trains
sultans72411833sulta_ns
suntans72111733sunta_ns
sustain738773sustain_
swains94513953s__wains
tains54936323___tains
terrains8410323terrains
tertians839103tertians
ventails1139823ventails
vervains1435293vervains
vexations1937753vexations
zeatins16311733zeat_ins

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 Filter1786911461620.436409841.7
2DLD Change Limit1461621347.07620656.0
3Display Results1341340.0502680.0
 (SQL Overall)1786911347.56223630.1
 
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.