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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

133 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
theorem123627(None) 
theorems1344691theorems
theorbo1243742theorbo
theories11311592theories
theory121098362theor_y
there87527392the_re_
theres96525472the_res
therm106018022the_r_m
therme115814992the_rme
cheered133713293cheered
cheerer123511753cheerer
chetrum1445343chetrum
chevre14318313chevre_
chevres15379793chevres
chevret153310633chevret
chore105126763ch_ore_
chorea115216083ch_orea
chored125321883ch_ored
chores114828023ch_ores
harem104924453_h_arem
hearer94323643_hearer
heired103813043_heired
here76447103_he_re_
heres86245903_he_res
herm95636153_he_r_m
heroes94923823_heroes
phellem1435833phellem
phloem1335713phlo_em
sheared114516003sheared
shearer104414683shearer
sheered113515453sheered
sheerer103813843sheerer
shore85432653sh_ore_
shored105723653sh_ored
shores94830413sh_ores
tabored102810563tabored
taborer9269293taborer
taboret92916113taboret
teared75722153t_eared
tearer64822903t_earer
teem66132603t_e__em
tenrec837513t_enrec
term66233153t_e_r_m
terret63425623t_erret
thairm1156963thair_m
tharm105916643th_ar_m
theater104014253theater
theatre10358493theatre_
theatres11298633theatres
thebe107515433the_be_
thebes115914493the_bes
thecae11299653thecae_
thee78039063the__e_
theine94814923theine_
theines104013233theines
their85512153their__
theirs94610353their_s
theism1139483the_ism
them97427043th___em
theme105921733the_me_
themed125912583the_med
themes115319253the_mes
thence112010843thence_
theocrat1346353theocrat
theolog1146153theolog
theonomy1644543theonomy
theorbos1343643theorbos
theoretic1446663theoretic
theorise1137873theorise
theorised1344923theorised
theorises1247813theorises
theorist1149553theorist
theorize2047073theorize
theorized2245803theorized
theorizer2144863theorizer
theorizes2147073theorizes
thereat104315243the_reat
thereby1534633the_reby
therein102310353the_rein
theremin13107283the_remin
thereof13168063the_reof
thereon10199263the_reon
thereto1038993the_reto
thermel12569893thermel
thermes126214613thermes
therms115914873the_rms
theroid11313403theroid
these86519013the_se_
theses96517973the_ses
theurgy1442733theurgy
thewier1336063thewier
thiourea1193073thiourea
thiram1139963th_iram
thole85620843th_ole_
tholed105113873th_oled
tholes94919783th_oles
thorax1638253th_orax
thoria93012893th_oria
thoric114314043th_oric
thorium12208413th_orium
thorn85318703th_or_n
thorned11479403th_orned
thorns95314103th_orns
thorny12509843th_orny
thoro86217873th_or_o
thoron94713903th_oron
thorp104414263th_or_p
thorpe113610093th_orpe
thorpes125010353th_orpes
thorps113610893th_orps
those85218143th_ose_
thoued10429003th_oued
three87526913th__ree
threw1117315713th__rew
throe89321423thro_e_
throes97518673thro_es
throne98517603throne_
throned115412173throned
thrones105715843thrones
throve128012393throve_
thrower1386993thrower
thrum104713633th__rum
tiered73613973tie_red
tore47359323t__ore_
tores55352673t__ores
totem74819373t__otem
tsores65113663t_sores
tutored837553tutored
where117019423whe_re_
wheres125917433whe_res
whore116018043wh_ore_
whored135512123wh_ored
whores125617103wh_ores

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 Limit1340271336.37321030.4
3Display Results1331330.0462891.3
 (SQL Overall)1786911336.80926243.4
 
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.