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

160 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
thereon1019926(None) 
hereon93914361_hereon
therein102310351therein
thereof13168061thereof
whereon13196501whereon
herein93717792_herein
hereof123212372_hereof
heron85025502_her_on
pereon83517452_pereon
there87527392there__
thereat104315242thereat
thereby1534632thereby
therefor1494452therefor
theremin13107282theremin
theres96525472there_s
thereto1038992thereto
thereupon1492572thereupon
therian10311292therian
thermion1345932thermion
thermos124610752thermos
thoron94713902thor_on
wherein13216592wherein
whereof16185462whereof
cheero114712933cheero_
cheeros123711633cheeros
cheroot12413693cheroot
cheveron1645263cheveron
chevron1575783chevron
chorion12311773chorion
ethephon1643473ethephon
ethereal1146783ethereal
gherao1036753gherao_
gherkin1544043gherkin
guerdon944343guerdon
hegemon1345173_hegemon
here76447103_here__
hereat93527413_hereat
hereby14468333_hereby
heres86245903_here_s
heresy125011233_heresy
hereto9313693_hereto
hereupon1383143_hereupon
heriot9422343_heriot
hern76134893_her__n
hero74635783_her_o_
heroes94923823_heroes
heroin94420593_heroin
herons94820543_her_ons
heros84930863_her_os
merlon83012353_merlon
mezereon1942233mezereon
operon8811773oper_on
pereion9312053_pereion
pereons92815003_pereons
perron83216623_perron
person83517873_person
serein63318463_serein
sermon8413553_sermon
shebean1235763shebean
shebeen1234553shebeen
sheen85023313she_e_n
shereef1337743shereef
sheroot10414373sheroot
stereo65317913stereo_
stereos74314973stereos
tarpon82812803t_arpon
teen45938203t_e_e_n
teflon937453t_eflon
telson6310293t_elson
tendon7312033t_endon
tenon53320513t_e_non
teredo7310783t_eredo
teredos839183t_eredos
terete6319333t_erete
termor84412513t_ermor
tern46134803t_er__n
ternion739493t_ernion
terreen7257573terreen
terror63811733t_error
teston6313303t_eston
thebe107515433thebe__
thebes115914493thebe_s
thee78039063the_e__
theelin1038003theelin
theelol1044273theelol
thegn95810903th__egn
thein85919023th__ein
theme105921733theme__
themed125912583theme_d
themes115319253theme_s
then78429693th__e_n
theogony1543463theogony
theolog1146153theolog
theorbo1243743theorbo_
theorbos1343643theorbos
theorem1236273theore_m
theorems1344693theorems
therapy1536613therapy
therefore1574593therefore
therefrom1752723therefrom
thereinto1243923thereinto
theremins14106053theremins
thereunto1252653thereunto
theriac1239143theriac
therians1138313therians
therm106018023ther__m
thermae125310503thermae
thermal125010973thermal
therme115814993ther_me
thermel12569893thermel
thermels13607763thermels
thermes126214613thermes
thermic1439333thermic
thermions1445333thermions
thermit12312013thermit
therms115914873ther_ms
theroid11313403theroid
theropod1445433theropod
these86519013these__
theses96517973these_s
thirteen1143303thirteen
thorn85318703thor__n
thoro86217873thor_o_
thorons104511913thor_ons
thrawn12769423th_rawn
thread105011093th_read
threap11569663th_reap
threat95020463th_reat
three87526913th_re_e
threep115910113th_reep
threeps12687043threeps
threes97117323th_rees
thresh12276863th_resh
threw1117315713th_re_w
thro77726423th_r_o_
throb109816853th_r_ob
throe89321423th_r_oe
throes97518673th_roes
throne98517603th_r_one
throng10539973th_r_ong
throw118719733th_r_ow
thrown1214911443th_rown
thyreoid1544773thyreoid
tierceron1152223tierceron
tiered73613973tiere_d
treason748763treason
treen55622753t__reen
tureen63312723t_ureen
turion6313163t_urion
turnon638193t_urnon
tween84413743twe_e_n
wheen115016053whe_e_n
where117019423where__
whereas13448903whereas
whereat134311923whereat
whereby1842913whereby
wheres125917433where_s
whereto1346063whereto
whereupon1771813whereupon
whoreson1444013whoreson

Search took 8 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.440406115.9
2DLD Change Limit1340271607.11018850.5
3Display Results1601600.0463478.3
 (SQL Overall)1786911607.59623524.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.