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

81 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
odist642191(None) 
odists749851odists
adit56443662adi_t
adits66523712adits
adust64117452adust
agist66325582agist
alist56136782alist
aorist64827872aorist
cist67244972_cist
deist64633592deist
didst74619622_didst
diet57357542_diet
dint56759062_dint
dipt77339332_dipt
dirt55550392_dirt
dis46459902_dis_
disc76123242_disc
dish86328342_dish
disk96625842_disk
diss56434492_diss
dit47071342_di_t
dits56450532_dits
doest65829522doest
doit56347852doi_t
doits66223672doits
dost57248352_dost
dust57142532_dust
edict84722282edict
edit54934872edi_t
edits65819032edits
exist124618942exist
feist86230072feist
fist76248432_fist
foist85730972foist
gist56046772_gist
grist65529872grist
heist87030912heist
hist76551552_hist
hoist86433212hoist
holist94723212holist
idiot6718862idiot
iodise74214942iodise
iodism93611132iodism
joist125125652joist
kist86540812_kist
list47055352_list
maist75535682maist
midst85922562midst
mist66154542_mist
modest93818452modest
modish123813542modish
modiste1039282modiste
moist76033582moist
monist84324982monist
neist54628442neist
nudist73813322nudist
oast47156322o_ast
obis66226842obis_
obit66837082obi_t
obits74617552obits
oboist8312682oboist
odas57230262odas_
oddest81710862oddest
oddish11107652oddish
odds68919932odds_
odes57243242odes_
odic74920582odi_c
odium83413032odium
ods47546222od_s_
oldest72114092oldest
oldish10169312oldish
omit65337372omi_t
omits75018262omits
oust46747442o_ust
sadist74221352sadist
shist84829612shist
twist86820982twist
waist86132382waist
whist115322952whist
wist78049302_wist
wrist84827562wrist

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.330541487.9
2DLD Change Limit53800811.79629955.5
3Display Results81810.0136230.8
 (SQL Overall)178691812.13983539.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.