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

232 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
hereof12321237(None) 
hereon93914361hereon
thereof13168061thereof
whereof16185461whereof
here76447102here__
hereat93527412hereat
hereby14468332hereby
herein93717792herein
heres86245902here_s
heresy125011232heresy
hereto9313692hereto
heriot9422342heriot
hero74635782her_o_
heroes94923822heroes
heron85025502her_on
heros84930862her_os
herself1337622herself
pereon83517452pereon
reroof9315002reroof
shereef1337742shereef
thereon10199262thereon
whereon13196502whereon
aero45435343aer_o_
beef96233683be_e_f
behoof1458683behoof
bereft114317303bereft
beret74946363bere_t
berets85822523berets
cere66741473cere__
cereal8315833cereal
cered85227443cere_d
ceres75540013cere_s
cereus85215523cereus
cero66329453cer_o_
ceros74726073cer_os
cheero114712933cheero_
cheeros123711633cheeros
cheroot12413693cheroot
dere56845903dere__
ere36352773_ere__
erect74129333_erect
erenow937373_erenow
ergo56420153_ergo_
ergot65422893_ergot
eros45238453_er_os
error53712233_error
fere76342233fere__
feres86038183fere_s
fervor1235643fervor
gerent73223103gerent
gherao1036753gherao_
haeres94017033haere_s
harbor11410723harbor
hare76255733hare__
hared95742183hare_d
hareem114312063hareem
harem104924453hare_m
harems115513823harems
hares86255543hare_s
harlot94422803harlot
harrow122610773harrow
hearer94323643heare_r
hearers104319783hearers
hebe96424703hebe__
hebes105521673hebe_s
hector113312653hector
heder95623643hede_r
heders104119763heders
heed86437603he_e_d
heeds95420423he_eds
heel75034223he_e_l
heels85625533he_els
heeze175313483he_eze
hegemon1345173hegemon
heirdom1344493heirdom
heired103813043heire_d
heiress1036813heiress
helio85321193helio_
helios94816633helios
hello86522983hello_
hellos95321683hellos
helo75332853he_lo_
helos84928063he_los
helot85332683he_lot
heme95034413heme__
hemes105031083heme_s
her66547813her___
herald10311343herald
herb94730963her__b
herbal112513493herbal
herbed123513453herbed
herbs105520503her_bs
herby134715313her_by
herd84933063her__d
herded114215643herded
herder104516463herder
herders113914123herders
herdic123112303herdic
herds96424683her_ds
heredes11313133heredes
heretic12314833heretic
hereupon1383143hereupon
heriots10312063heriots
heritor10310563heritor
herl75834553her__l
herls85226433her_ls
herm95636153her__m
herma105318883her_ma
hermae115314473hermae
hermai118912863hermai
hermit11519443hermit
herms105626433her_ms
hern76134893her__n
hernia9312293hernia
herns84825583her_ns
heroic113516923heroic
heroin94420593heroin
herons94820543herons
herpes115517323herpes
herry114922473her_ry
hers75844873her__s
hertz174919043her_tz
hetero9312633hetero
heteros10312683heteros
hewed125619433hewe_d
hewer115719933hewe_r
hewers123715273hewers
hexed165615763hexe_d
hexer155116683hexe_r
hexers165612753hexers
hexes155123043hexe_s
hire75538963hire__
hired95226263hire_d
hiree85427803hire_e
hirees95117293hirees
hirer85423123hire_r
hirers94518063hirers
hires86134343hire_s
hoof106036583h__oof
horror988723horror
jerboa1535633jerboa
jereed144012073jereed
keef115830003ke_e_f
kerf115827463ker__f
mere67244443mere__
merely111312593merely
merer75126233mere_r
meres75143573mere_s
merest84725113merest
merlon83012353merlon
merlot83217603merlot
meteor84910073meteor
nereid7312923nereid
nereis6315343nereis
nerol51017813ner_ol
pareo74632603pareo_
pareos87023773pareos
pere66450263pere__
perea75026443pere_a
pereia85217983pereia
pereion9312053pereion
pereons92815003pereons
peres76246643pere_s
period9314983period
pernod9310453pernod
perron83216623perron
person83517873person
preop94715873_preop
prof96134663_pr_of
proof105221533_proof
reef74938213__reef
ref66053293__re_f
reif76937653__reif
reproof1238783reproof
reread71715433reread
reredos838633reredos
rerent63832453rerent
reroofs1037943reroofs
roof75738833__roof
sere46153473sere__
sered65737293sere_d
serein63318463serein
serene63522353serene
serer55935513sere_r
seres55448893sere_s
serest64831613serest
serf76340113ser__f
serif84132133ser_if
sermon8413553sermon
serow86720443ser_ow
servo84516683servo_
servos93812723servos
shereefs1433863shereefs
sherif122915243sher_if
sheriff16287693sheriff
sheroot10414373sheroot
stereo65317913stereo_
stereos74314973stereos
teredo7310783teredo
teredos839183teredos
terete6319333terete
termor84412513termor
terror63811733terror
there87527393there__
thereat104315243thereat
thereby1534633thereby
therefor1494453therefor
therein102310353therein
theres96525473there_s
thereto1038993thereto
thermos124610753thermos
tref77030993_tre_f
unroof9410193unroof
verso85314633verso_
versos93812803versos
vireo84816453vireo_
vireos94212453vireos
were76238333were__
werewolf1743453werewolf
werwolf1644573werwolf
where117019423where__
whereas13448903whereas
whereat134311923whereat
whereby1842913whereby
wherein13216593wherein
wheres125917433where_s
whereto1346063whereto
xerox1138623xer_ox
zero134822473zer_o_
zeroed16409413zeroed
zeroes154314343zeroes
zeros144918113zer_os

Search took 6 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 Filter1786911127160.390458182.1
2DLD Change Limit1127162325.42020796.3
3Display Results2322320.0633682.5
 (SQL Overall)1786912325.87330425.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.