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

131 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
wherein1321659(None) 
herein93717791_herein
therein102310351therein
whereon13196501whereon
gherkin1544042gherkin
hereon93914362_hereon
heroin94420592_heroin
serein63318462_serein
theremin13107282theremin
thereon10199262thereon
wheen115016052whe_e_n
where117019422where__
whereas13448902whereas
whereat134311922whereat
whereby1842912whereby
whereinto1552342whereinto
whereof16185462whereof
wheres125917432where_s
whereto1346062whereto
berlin83116373_berlin
checkrein2042903checkrein
cheering143612703cheering
cheerio12379313cheerio
chervil1534953chervil
choreic1438703choreic
devein1039143_devein
gherkins1643993gherkins
harmin113117393_harmin
harpin113614383_harpin
hemin103620933_he_min
herdic123112303_herdic
herding122915123_herding
here76447103_here__
hereat93527413_hereat
hereby14468333_hereby
hereinto1145433_hereinto
hereof123212373_hereof
heres86245903_here_s
heresy125011233_heresy
heretic12314833_heretic
hereto9313693_hereto
hermit11519443_hermit
hern76134893_her__n
hernia9312293_hernia
heroic113516923_heroic
heroine103517483_heroine
heroins103518013_heroins
heron85025503_her_on
herring113615883_herring
hordein1138753_hordein
jerkin17258113_jerkin
merlin83916683_merlin
murein8311763_murein
nereid7312933_nereid
nereis6315343_nereis
pereia85217983_pereia
pereion9312053_pereion
pereon83517453_pereon
pheresis1377633pheresis
pterin81014153pter_in
rein46040893___rein
sereins73716123_sereins
serin55434443_ser_in
shebean1235763shebean
shebeen1234553shebeen
sheen85023313she_e_n
sheering123715103sheering
shereef1337743shereef
sherif122915243sher_if
sherris10168803sherris
theelin1038003theelin
thein85919023th__ein
there87527393there__
thereat104315243thereat
thereby1534633thereby
thereinto1243923thereinto
theremins14106053theremins
thereof13168063thereof
theres96525473there_s
thereto1038993thereto
therian10311293therian
thermic1439333thermic
thermion1345933thermion
thermit12312013thermit
theroid11313403theroid
verdin103113023_verdin
vermin113414523_vermin
warren95012853warre_n
wedeln10326693w_edeln
ween75835463w_e_e_n
welkin1337313w_elkin
were76238333w_ere__
wharfing1834683wharfing
wheaten1336403wheaten
whee105429593whe_e__
wheel115515333whe_e_l
wheelie1336193wheelie
wheeling15318593wheeling
wheels123811713whe_els
wheens124610613whe_ens
wheep136214353whe_e_p
wheeping17337103wheeping
wheeps14439953whe_eps
wheeze21276813whe_eze
wheezing24315383wheezing
wheezy24244523whe_ezy
whelming17304923whelming
whelping17245333whelping
when105723043wh__e_n
whereunto1551783whereunto
whereupon1771813whereupon
wherever1743823wherever
wherewith2152713wherewith
wherried15175013wherried
wherries14179023wherries
wherry15477333wher_ry
wherrying1952993wherrying
wherve15568113wher_ve
wherves16548053wherves
whetting1535973whetting
wheyey1834323wheye_y
whin105225693wh___in
whirling15237163whirling
whirring15286283whirring
whiten124111923white_n
whore116018043whore__
whored135512123whore_d
whores125617103whore_s
whoreson1444013whoreson
whoring142910293whor_ing
wren78221683w__re_n

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.436409841.7
2DLD Change Limit1340271316.87319500.5
3Display Results1311310.0502620.0
 (SQL Overall)1786911317.35924282.0
 
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.