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 “exile” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

84 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
exile12611765(None) 
axile126020511axile
edile64819491edile
exiled144712461exiled
exiler134712181exiler
exiles134816401exiles
exine125518491exine
aedile73716652aedile
agile65122262agile
anile54634462anile
axil116424452axil_
axils127217502axils
axite125218252axite
axle116424602ax_le
bile66147182_bile
chile105626892chile
decile94619212decile
defile105216662defile
dexie134716892dexi_e
eagle64219482eagle
edible969352edible
ediles74016982ediles
eide55832232e_ide
elide64922642elide
elite56230182elite
enisle63412092enisle
ensile62616472ensile
etoile6312262etoile
evil75318072evil_
eviler94811892eviler
evils84114262evils
evite85317682evite
exalt123018532exalt
excel1437742excel
excide1638422excide
exciple1874682exciple
excise1538552excise
excite15310882excite
exhale1636872exhale
exilers14419732exilers
exilic1597782exilic
exines135715802exines
exing136016812exing
exist124618942exist
exit114428672exi_t
exited144712522exited
exits125515912exits
expel1448232expel
expire1538022expire
exude134010292exude
exult122814122exult
file75446642_file
flexile1735072flexile
guile64521132guile
ixtle12168012ixtle
maile75232222maile
mile66352572_mile
oxide131210952oxide
oxime1498432oxime
penile82219602penile
pile65649692_pile
refile95122372refile
resile64627672resile
retile65929672retile
revile94921612revile
rexine134719442rexine
rile45650532_rile
sedile73517232sedile
senile63420212senile
sexily1638852sexily
sextile1438572sextile
smile74823922smile
spile75230082spile
stile54931572stile
textile1437222textile
tile45451442_tile
toile54626492toile
utile54718932utile
vexil1538962vexil_
vexils1647172vexils
vile76139802_vile
voile84719722voile
while115418692while
wile75944372_wile

Search took 3 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 Filter178691538000.0802233637.5
2DLD Change Limit53800841.98327130.6
3Display Results84840.0761105.3
 (SQL Overall)178691842.13983539.5
 
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.