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

207 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
textile143722(None) 
sextile1438571sextile
textiles1536831textiles
centile94217182centile
exile126117652_ex_ile
fertile10311732fertile
gentile83515292gentile
reptile93914082reptile
retile65929672re_tile
sectile9311972sectile
sextiles1537642sextiles
tactile9310612tactile
teatime9310082teatime
tectite9310582tectite
tektite1136882tektite
tensile72612732tensile
tentie62521182tenti_e
testicle1037442testicle
testily102910802testily
texture1497082texture
tortile7313192tortile
aedile73716653ae_dile
axile126020513_ax_ile
bastile9313913bastile
bedtime1236973bedtime
beetle8311673beet_le
beguile1056933beguile
besmile1137463besmile
betide95115973be_tide
betime105914833be_time
betise85616273be_tise
centiles103615813centiles
centime114513033centime
decile94619213de_cile
defile105216663de_file
denticle1137773denticle
dentil74017883dentil_
dentiled1039743dentiled
dentils84115583dentils
dentine83320243dentine
destine83719953destine
dexie134716893dex_i_e
dextrine1688253dextrine
ductile1048483ductile
edile64819493_e_dile
ensile62616473_ensile
entice81316863_entice
entire61617703_entire
entitle7610293_entitle
erectile1039513erectile
etoile6312263_etoile
excide1638423_excide
exciple1874683_exciple
excise1538553_excise
excite15310883_excite
exhale1636873_exhale
exiled144712463_ex_iled
exiler134712183_ex_iler
exiles134816403_ex_iles
exine125518493_ex_ine
expire1538023_expire
extol1247893_extol_
extoll1334863_extoll
extols1337683_extols
febrile1237153febrile
festive1339773festive
fettle93713123fe_ttle
fictile1238023fictile
flexile1735073flex_ile
flextime2042813flextime
futile93914953_futile
gentil74115123gentil_
gentiles93713523gentiles
gentle74014513gent_le
heftily1635763heftily
hostile10312553hostile
inutile739883inutile
ixtle12168013_ixt_le
kettle104311613ke_ttle
lentil64315393lentil_
lentils73912973lentils
meatily12311093meatily
mettle83815723me_ttle
motile83818343_motile
nestle63013953nest_le
nettle64514583ne_ttle
pantile93918483pantile
pectize20259913pectize
penile82219603pe_nile
pensile92713543pensile
peptide122910693peptide
peptize20279483peptize
pestle83215843pest_le
petiole9311303pe_tiole
petite84320653pe_tite
pettily1238173pettily
pettle84116053pe_ttle
refile95122373re_file
reptiles103913073reptiles
resile64627673re_sile
restive10315933restive
restyle1038763restyle
reticle94112623re_ticle
retie55735303re_ti_e
retiled84420513re_tiled
retiles74426993re_tiles
retime85321803re_time
retine66237333re_tine
retire64927013re_tire
retitle73913093re_title
revile94921613re_vile
rexine134719443rex_ine
rutile65217683_rutile
saxatile1544953saxatile
sedile73517233se_dile
senile63420213se_nile
septime1138803septime
servile10310643servile
sessile739523sessile
sestine73017923sestine
settle63915663se_ttle
sexily1638853sex_ily
sextuple1762773sextuple
steatite8310583steatite
sterile7316603ste_rile
stile54931573__stile
subtile91912623subtile
tartily103511573tartily
tastily103311643tastily
tattie64817513tatti_e
tattily10409993tattily
tattle64115653t_attle
taxable1639073taxable
taxite13511303tax_ite
taxwise1734253taxwise
tealike111111083tealike
tearily10311153tearily
teatimes1039443teatimes
teazle15329553te_azle
techie11511723techi_e
techily1537123techily
tectal83713253tectal_
tectites1039993tectites
teethe94511313teet_he
tekkie934203tekki_e
tektites1236613tektites
tele45040873te___le
telltale844423telltale
temple102811333te_mple
tenable93214493tenable
tenail64516113tenail_
tenaille846813tenaille
tenails73713923tenails
teniae64517353te_niae
tensible1037243tensible
tensive10269913tensive
tentacle1037693tentacle
tentage81010643tentage
tenthly1335743tenthly
tentier73815923tentier
tenting84621153tenting
tentlike1236903tentlike
tequila1644583tequila
tergite8311003tergite
termite9313893termite
termtime1244773termtime
terrible1046643terrible
terrine72517573terrine
tertial7313863tertial
tertials8510073tertials
tertian7511193tertian
testable101412623testable
testae64216253test_ae
testate73916233testate
testee64323303test_ee
testicles1146773testicles
testier74015643testier
testify13246943testify
testing86021053testing
testis64916713testi_s
text116033933text___
textless15245793text_less
texts125515043text__s
textual1444603textual
textured1695483textured
textures1597523textures
texturize2544283texturize
tile45451453___tile
title54721073t_it_le
tittie63213153titti_e
tittle63613323t_ittle
toile54626493t__oile
tontine72316143tontine
tootle62613813toot_le
toxine133114123tox_ine
tractile10311073tractile
treatise8311103treatise
trestle72611363trest_le
tuftily1335573tuftily
turtle63213573turt_le
twattle1064273twattle
utile54718933__utile
verbile1249863verbile
vestige1137433vestige
vexil1538963vex_il_
vexils1647173vex_ils
zestily19167563zestily

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.403443402.0
2DLD Change Limit1340272077.36018210.2
3Display Results2072070.0802587.5
 (SQL Overall)1786912077.84322783.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.