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

96 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
neath8602028(None) 
death94822521death
eath75735661_eath
heath115724281heath
neat46356781neat_
neats55931901neats
bath95940082_bath
beach124623892beach
beat66168302beat_
beats76042252beats
beneath1236972beneath
berth104917882berth
beth96629232be_th
breath113916272breath
dearth104212512dearth
deash95617242deash
deaths105914442deaths
deathy134210232deathy
depth114311852depth
each95530582_each
earth85023052_earth
eat36989052_eat_
eats47054872_eats
enate54428152enate
eth66630982_e_th
feat76458222feat_
feats86432752feats
hath105933912_hath
health124712142health
hearth125315212hearth
heat77061422heat_
heaths126316382heaths
heathy156111212heathy
heats85838402heats
heth107028022he_th
inearth1037042inearth
lath76640382_lath
leach105422522leach
leash85519212leash
loath84918602loath
math95437452_math
meat66359602meat_
meats75034052meats
meaty107021312meaty
meth95827842me_th
nah69847002n_a_h
natch105018222n_atch
neap66927012nea_p
neaps75618322neaps
near45236502nea_r
nears55529422nears
neaten64214542neaten
neater64424312neater
neatly93812482neatly
negate72915572negate
neigh94912382neigh
nerts55924982nerts
nertz145117452nertz
nest45548732nest_
nests55728002nests
net36670292ne_t_
nets45941532ne_ts
nett46643232ne_tt
netts55320722netts
netty85816762netty
newt76933742newt_
newts86015282newts
next116631082next_
ninth8314582ninth
north86018272north
nth66320592n__th
oath76132152_oath
path99134912_path
peach125422492peach
peat65967932peat_
peats76140192peats
peaty105725692peaty
rath76037662_rath
reach105123882reach
reata54225392reata
seat47575562seat_
seats54844342seats
sheath12412892sheath
snath86419802snath
swath115920382swath
teach105221122teach
teat45963632teat_
teats55636812teats
teeth87315852teeth
tenth85421832tenth
teth76327892te_th
unearth1037062unearth
wealth12379222wealth
wrath115715872wrath
wreath124111192wreath
yeah106725412yea_h

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.310576422.6
2DLD Change Limit53800961.66032409.6
3Display Results96960.0303200.0
 (SQL Overall)178691962.00089345.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.