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

92 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
theme10592173(None) 
heme95034411_heme
rheme106214051rheme
thebe107515431thebe
thee78039061the_e
them97427041them_
themed125912581themed
themes115319251themes
there87527391there
therme115814991therme
these86519011these
thyme134612471thyme
ahem97225362ahem_
chemo12313632chemo
chime125322592chime
chyme156512502chyme
creme94319322creme
deme76536282_deme
eme55837182__eme
ethene93312922ethene
feme96130542_feme
ghee85726112ghe_e
hame97043132_hame
hebe96424702_hebe
hem86148732_hem_
hemes105031082_hemes
hemp115725622_hemp
hems95534942_hems
here76447102_here
home98042442_home
meme85330552_meme
rhemes115913182rhemes
rhyme13479552rhyme
scheme1379632scheme
seme65836652_seme
shame105726702shame
tame66343662t_ame
taxeme1536252taxeme
tee38366872t_e_e
teem66132602teem_
teemed95114872teemed
teemer85515742teemer
teems76019782teems
tele45040872t_ele
temp85323332t_emp
thae76825562th_ae
thane86122532thane
the67436052th__e
thebes115914492thebes
theca103311452theca
thecae11299652thecae
theft114118132theft
thegn95810902thegn
thein85919022thein
theine94814922theine
their85512152their
then78429692the_n
thence112010842thence
thens85921832thens
theres96525472theres
therm106018022therm
thermae125310502thermae
thermel12569892thermel
thermes126214612thermes
therms115914872therms
theses96517972theses
thesp105410312thesp
theta83414572theta
thew108226232the_w
thews117416192thews
thewy146311852thewy
they107223752the_y
thieve1235962thieve
thine85026862thine
thole85620842thole
those85218142those
three87526912three
throe89321422throe
thumb124511282thumb
thump126211572thump
thymes144810742thymes
thymey17426312thymey
thymi13418632thymi
thymy16437922thymy
time66235012t_ime
tome67543192t_ome
toneme8312102toneme
tree47745812tre_e
twee76827082twe_e
tyee75131422tye_e
whee105429592whe_e
where117019422where

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.296603685.8
2DLD Change Limit53800921.54634799.5
3Display Results92920.0303066.7
 (SQL Overall)178691921.87295454.6
 
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.