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

75 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
tilth8551536(None) 
filth115015821filth
tilt46252421tilt_
tilths9459371tilths
tilts55325611tilts
airth85621022airth
atilt54828472atilt_
birth105619872birth
fifth145210922fifth
filch134813322filch
filths12389782filths
filthy15356422filthy
firth115819532firth
gilt56348542gilt_
gilts64924262gilts
girth95618842girth
hilt75850712hilt_
hilts86924412hilts
jilt115839422jilt_
jilts124717412jilts
kilt86144412kilt_
kilts95122182kilts
kilty125213892kilty
kith115826352ki_th
lilt46349942lilt_
lilts55822802lilts
milch124413372milch
milt65455812milt_
milts75430712milts
milty104720072milty
mirth106418892mirth
ninth8314582ninth
pith95432692pi_th
silt46558192silt_
silts55330822silts
silty84721632silty
sith75435152si_th
sixth155512232sixth
spilth11469732spilth
stilt54831982stilt_
stilts67915302stilts
teeth87315852teeth
tenth85421832tenth
teth76327882t_eth
tight93626502tight
til36350262til__
tilak91011552tilak
tilde65017342tilde
tile45451442til_e
tiled64832942tiled
tiler56131022tiler
tiles55542102tiles
till45941202til_l
tills54631702tills
tils45739612til_s
tilted74616862tilted
tilter63417692tilter
tint46758862tint_
tints56030922tints
tit36771042ti_t_
tithe85319702ti_the
titi47130612ti_ti
title54721072title
tits46145032ti_ts
titty85316652titty
tooth88020182tooth
trilith10310512trilith
troth85622202troth
truth85214152truth
width12310962width
wilt76246292wilt_
wilts85023502wilts
with105730472wi_th
yirth116513752yirth
zilch19438122zilch

Search took 2 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.1731032896.0
2DLD Change Limit53800751.65632487.9
3Display Results75750.0302500.0
 (SQL Overall)178691751.85996122.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.