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

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

79 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
neolith106878(None) 
eolith93013901_eolith
neoliths1144931neoliths
aerolith1149832aerolith
eoliths10318572_eoliths
neolithic1483932neolithic
oolith93813242_oolith
otolith10108282otolith
regolith1247542regolith
urolith1048782urolith
xenolith1845652xenolith
zeolite1638902zeolite
abolish12311503abolish
acrolith1348453acrolith
aeolian738633aeolian
aerolite8315053aerolite
aeroliths1245653aeroliths
ceilidh1345363ceilidh
ceorlish1345383ceorlish
coolish12312523coolish
coolth1139513cool_th
delish105215613de_lish
demolish1447833demolish
depolish1446943depolish
elite56230183_e_lite
english1137953english
enolic8413353enoli_c
eolian6312593_eolian
eolithic1375853_eolithic
foolish1339613foolish
goliath1145933_goliath
health124712143heal_th
hellish13310723hellish
iolite63221983_iolite
kryolith1843213kryolith
megalith1448243megalith
monolith1349673monolith
neath86020283ne__ath
nebbish1444253nebbish
neglige934873neglige
neigh94912383ne__igh
nellie63614813nelli_e
nellies73418723nellies
neology11238293neology
neonate7311333neonate
nerdish1137103nerdish
neroli61111163neroli__
nerolis71012783neroli_s
netlike11308913netlike
newish1237903ne_wish
niobite937953niobite
norite63221133n_orite
north86018273n_o_rth
nullity1037363nullity
oolite63319603_oolite
ooliths10268323_ooliths
otoliths11104513otoliths
paleolith1445313paleolith
pelite84323003pe_lite
penlite9313243penlite
perlite9317323perlite
pisolith1346553pisolith
polish114916723_polish
polite83625073_polite
polity113015863_polity
reality10313573reality
regoliths1344113regoliths
relish93916953re_lish
relit55340683re_lit_
repolish1347933repolish
tallith102913063tallith
trilith10310513trilith
unpolite1049173unpolite
uroliths1154923uroliths
wealth12379223weal_th
xenoliths1943313xenoliths
zenith1839073ze_nith
zeolites1738383zeolites
zeolitic1947463zeolitic

Search took 7 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.390458182.1
2DLD Change Limit134027796.28321331.7
3Display Results79790.0302633.3
 (SQL Overall)178691796.70326658.4
 
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.