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

119 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
herself133762(None) 
hereof123212372her_eof
himself1544282himself
hirsel9138682hirsel_
hirsels10128342hirsels
hisself1335912hisself
ourself1057452ourself
tersely1038112tersely
theirself1551262theirself
aversely1444853aversely
berseem1166463berseem
berserk1334913berserk
densely1146713densely
dorsel75315503dorsel_
dorsels84412573dorsels
easel54521113_easel_
easels65914553_easels
enserf9310763_enserf
erosely1038083_erosely
erses55826803_erse_s
ferrel92810203ferrel_
ferrels10248623ferrels
hansel95214373hansel_
hansels104011653hansels
harshly1636273harshly
harslet10315653harslet
hassel95614213hassel_
hassels104311013hassels
hearse94114273hearse__
hearsed113811403hearse_d
hearses104414533hearse_s
heel75034223he__el_
heels85625533he__els
herald10311343her_ald
herbal112513493herbal_
herbals122710603herbals
herbed123513453herbe_d
herded114215643herde_d
herder104516463herde_r
herders113914123herders
here76447103her_e__
hereat93527413her_eat
hereby14468333her_eby
herein93717793her_ein
hereon93914363her_eon
heres86245903her_e_s
heresy125011233her_esy
hereto9313693her_eto
herl75834553her__l_
herls85226433her__ls
heroes94923823heroe_s
herpes115517323herpe_s
hers75844873hers___
hirseled12106253hirseled
hirsle9159573hirs_le
hirsled11118113hirsled
hirsles101510073hirsles
hoarsely1444363hoarsely
horse86132653horse__
horsed105321083horse_d
horsefly1744873horsefly
horses94729343horse_s
horsey125115403horse_y
horsily1338843horsily
hosel86024813h_osel_
hosels94218603h_osels
housel95217043housel_
housels105312133housels
itself946263_itself
jersey1636333jerse_y
jerseys1733243jerseys
kernel104010593kernel_
kernels11417953kernels
kersey1336793kerse_y
kerseys1433993kerseys
merely111312593mer_ely
morsel85815893morsel_
morsels94112653morsels
myself1445593_myself
nonself1078513nonself
oneself1046073oneself
oversell1137473oversell
persalt9315413persalt
perse75429523perse__
perses85428063perse_s
presell939303presell
resell64215203re_sell
self75138293___self
shereef1337743sher_eef
teasel63914983teasel_
teasels74311313teasels
tensely1037363tensely
tercel83612993tercel_
tercels94110363tercels
terse55026823terse__
terser67317823terse_r
tersest71713993tersest
thereof13168063ther_eof
thermel12569893thermel_
thermels13607763thermels
thyself1643033thyself
versal93013753versal_
verse84723583verse__
versed104515513verse_d
verser94516963verse_r
versers103813523versers
verses94223763verse_s
verset94327323verse_t
versets103913103versets
vessel937953vessel_
vessels1035933vessels
weasel93410523weasel_
weasels10468503weasels
weasely13317853weasely
wergeld1233183wergeld
wergelt1138583wergelt
werwolf1644573werwolf
whereof16185463wher_eof
yourself1442653yourself

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.436409841.7
2DLD Change Limit1340271196.48320673.6
3Display Results1191190.0502380.0
 (SQL Overall)1786911196.96925640.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.