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

107 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
whereon1319650(None) 
hereon93914361_hereon
thereon10199261thereon
wherein13216591wherein
whereof16185461whereof
herein93717792_herein
hereof123212372_hereof
heron85025502_her_on
pereon83517452_pereon
therein102310352therein
thereof13168062thereof
wheen115016052whe_e_n
where117019422where__
whereas13448902whereas
whereat134311922whereat
whereby1842912whereby
wheres125917432where_s
whereto1346062whereto
whereupon1771812whereupon
whoreson1444012whoreson
cheero114712933cheero_
cheeros123711633cheeros
cheroot12413693cheroot
cheveron1645263cheveron
chevron1575783chevron
chorion12311773chorion
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
there87527393there__
thereat104315243thereat
thereby1534633thereby
therefor1494453therefor
theremin13107283theremin
theres96525473there_s
thereto1038993thereto
thereupon1492573thereupon
therian10311293therian
thermion1345933thermion
thermos124610753thermos
thoron94713903thor_on
warren95012853warre_n
weakon13357623w_eakon
weapon11288113w_eapon
weason93210823w_eason
wedeln10326693w_edeln
ween75835463w_e_e_n
were76238333w_ere__
wheaten1336403wheaten
whee105429593whe_e__
wheel115515333whe_e_l
wheels123811713whe_els
wheens124610613whe_ens
wheep136214353whe_e_p
wheeps14439953whe_eps
wheeze21276813whe_eze
wheezy24244523whe_ezy
when105723043wh__e_n
wherefore18103903wherefore
wherefrom2052013wherefrom
whereinto1552343whereinto
whereunto1551783whereunto
wherever1743823wherever
wherry15477333wher_ry
wherve15568113wher_ve
wherves16548053wherves
wheyey1834323wheye_y
whiten124111923white_n
whore116018043whore__
whored135512123whore_d
whoredom1743283whoredom
whores125617103whore_s
whoresons1543863whoresons
widgeon1244143widgeon
wigeon1037223w_igeon
wren78221683w__re_n

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.423422437.4
2DLD Change Limit1340271075.68623571.4
3Display Results1071070.0462326.1
 (SQL Overall)1786911076.15529031.8
 
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.