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

167 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
sextant14291196(None) 
extant132714751_extant
sextan13389641sextan_
sextans14349261sextans
sextants15287381sextants
extent132714912_extent
reptant92817072reptant
saltant7316772saltant
sealant73118302sealant
seawant103613412seawant
secant84023292se_cant
seitan62613232seitan_
seitans73312302seitans
sejant133114482se_jant
sejeant1489722sejeant
servant10313622servant
sextain14257102sextain
sextains15246812sextains
sextet13916872sext_et
sexton133610792sexton_
sextons143710412sextons
statant7313122statant
bezant17814543be_zant
bezzant1746893bezzant
blatant9310673blatant
cetane8315283ce_tane
debutant1146183debutant
decant93524223de_cant
defiant11311923defiant
descant104315583descant
detent73624483de_tent
deviant11311313deviant
dextran1586163dextran_
dextrans1695983dextrans
distant83519953distant
eluant6315093_eluant
entrant7318873_entrant
errant6618733_errant
exact143516933_ex_act
exalt123018533_ex_alt
excitant1777353_excitant
exeunt1338703_exeunt
expand16236573_expand
expat14313813_expa_t
explant16310133_explant
extend14267523_extend
extents142610173_extents
extinct1646893_extinct
extort13513973_extort
extract16311013_extract
extranet15412993_extranet
exultant1545483_exultant
gelant72821673ge_lant
gellant83214053gellant
gestalt8411163gestalt
heptane1238363heptane
hesitant1149083hesitant
hexane16379533hex_ane
instant7815343instant
jessant1438443jessant
leant56737783le__ant
levant9314493le_vant
meant76537213me__ant
mediant103516703mediant
mutant8317693_mutant
natant6318733_natant
nonextant1646203nonextant
nutant6316383_nutant
octant81216553_octant
oscitant1046903oscitant
peasant9314923peasant
peccant13311733peccant
pedant9319493pe_dant
peltast9310513peltast
pendant10314853pendant
pennant9312493pennant
pentane9415743pentane
reactant10311433reactant
reboant9315093reboant
recant83228683re_cant
regnant8312843regnant
regrant8317323regrant
reliant7319243reliant
remnant9312633remnant
replant93318533replant
restart7320033restart
retint65633443re_tint
satang75711563s_atang
savant9416043s_avant
scant79735073s__cant
sealants82610743sealants
seaman84015903seaman_
seat47575563se__a_t
seating84130683seating
seawan94111223seawan_
seawans10379943seawans
seawants11337973seawants
secants93413893se_cants
sectary1238273sectary
sedan65620423se_dan_
sedans74816093se_dans
segment10312563segment
sent46963013se___nt
sentient8313633sentient
septa75518083septa__
septage1078403septage
septal84513383septa_l
septate9511873septate
septet8921133sept_et
sequent16410323sequent
sergeant9129403sergeant
serjeant1596473serjeant
serpent92916283serpent
serrano768463serrano
servants1137993servants
sestet6826203sest_et
sestina72711973sestina
sestine73017923sestine
seta45637313se_ta__
setae56026223se_ta_e
setal56430903se_ta_l
setenant849923setenant
seton55223543se_ton_
setons64620173se_tons
setout64719463se_tout
sett45949053se_t__t
setting83621393setting
sewan85921293se_wan_
sewans95215903se_wans
sexiest142112223sexiest
sexing144313893sex_ing
sexist133013483sex_ist
sexpot1539543sex_pot
sext117338093sex___t
sextarii1543183sextarii
sextets1497143sextets
sextette1544073sextette
sextile1438573sextile
sexto124415453sext__o
sextos134012163sext_os
sexts125118383sext__s
sexual1338413sexua_l
sheitan1036573sheitan_
sheitans1155603sheitans
slant55238703s__lant
sonant6621953s_onant
soutane7312063soutane
spirant9814293spirant
stand65923283s__tand
stane55933003s__tane
stang66424683s__tang
stank95823303s__tank
start55642313s__tart
stat47352693s__ta_t
stent55634513s__tent
stint57037663s__tint
stunt55328173s__tunt
sultan63012593sultan_
sultana7257803sultana
sultans72411833sultans
suntan62613003suntan_
suntans72111733suntans
tenant6322473te_nant
tetany959843te_tany
vegetant1246963vegetant
verdant11313293verdant
versant10313833versant

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.1561145455.1
2DLD Change Limit1340271677.28018410.3
3Display Results1671670.0632650.8
 (SQL Overall)1786911677.49923828.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.