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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

52 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
theremins1410605(None) 
theremin13107281theremin_
theelins1137642the_elins
therein102310352there_in_
thermions1445332ther_mions
thermits1338512ther_mits
gherkins1643993gher_kins
haemins122811403_h_aemins
harmins123716723_har_mins
hegemons1444893_hegemons
hemins113417573_h__emins
herein93717793_here_in_
heresies11312693_heresies
heretics13310503_heretics
hermits12312143_her_mits
heroins103518013_her_oins
pheresis1377633pheresi_s
reremind1147513_reremind
rereminds1244363_rereminds
sereins73716123_sere_ins
teeming103513093t_e_eming
teredines1049453t_eredines
terming104016003t_er_ming
termini93410813t_er_mini
terminus1037393t_er_minus
terrains8410323t_errains
theelin1038003the_elin_
theins95015423th__e_ins
theming133610473th__eming
theorems1344693theorem__s
therapies1447723therapies
thereinto1243923there_into
thereon10199263there_on_
theres96525473there___s
therewith1843543therewith
therians1138313ther_ians
thermals13518533ther_mals
thermels13607763ther_mels
thermes126214613ther_m_es
thermic1439333ther_mi_c
thermion1345933ther_mion
thermit12312013ther_mi_t
thermite1339033ther_mite
thermites1438043ther_mites
thermos124610753ther_m_os
therms115914873ther_m__s
thiamins1346633th_iamins
tholepins1443963tholepins
threeping15104803threeping
thrombins1684713th_rombins
thyroxins2243643thyroxins
wherein13216593where_in_

Search took 9 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 Filter1786911486410.453394461.4
2DLD Change Limit148641528.14018260.6
3Display Results52520.0163250.0
 (SQL Overall)178691528.60920756.3
 
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.