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

101 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
hisself133591(None) 
himself1544291himself
hassel95614212hassel_
hassels104311022hassels
herself1337622herself
hirsel9138682hirsel_
hirsels10128352hirsels
hissed104114452hisse_d
hisser94713792hisse_r
hissers104112312hissers
hisses94719352hisse_s
itself946262_itself
missel85216522missel_
missels94614812missels
ainsell796393ainsell
chisel112111943chi_sel_
chisels12219103chi_sels
diesel74410403diesel_
diesels8429143diesels
dishelm1335833dishelm
dispel9310323dispel_
dispels10310503dispels
disseat83816923disseat
dissect103614133dissect
dissed85220183disse_d
dissent84018683dissent
dissert83720693dissert
disses75225963disse_s
dossel74813643dossel_
dossels85511613dossels
fissile10269653fissile
hansel95214373hansel_
hansels104011663hansels
hassle93711593hass_le
hassled11358303hassled
hassles103411693hassles
hirseled12106253hirseled
hirsle9159573hirs_le
hirsled11118113hirsled
hirsles101510073hirsles
hiss75629213hiss___
hissier103410503hissier
hissies103915823hissies
hissiest112911093hissiest
hissing114213143hissing
hissy116112123hiss__y
histed104420243histe_d
hosel86024823h_osel_
hosels94218613h_osels
hostel93914153hostel_
hostels103712323hostels
housel95217053housel_
housels105312143housels
issei568573_isse_i
isseis638563_isseis
kissed114412853kisse_d
kisser104212453kisse_r
kissers114211293kissers
kisses104217333kisse_s
listel64214743listel_
listels74212433listels
misrely12319613misrely
missal84314903missal_
missals93914433missals
misseat93617243misseat
missed94423603misse_d
missend104411373missend
missent94318713missent
misses85130873misse_s
misset85028153misse_t
missets94516573missets
missile92815403missile
misspell1244303misspell
misspelt1247273misspelt
mussel83412903mussel_
mussels9419843mussels
myself1445593_myself
nonself1078513nonself
oneself1046073oneself
ourself1057453ourself
passel85117003passel_
passels93913023passels
pissed94816933pisse_d
pisser84416383pisse_r
pissers95014753pissers
pisses84525083pisse_s
rissole739783rissole
self75138293___self
shelf115221113__shelf
sisses64520603sisse_s
tassel66014773tassel_
tassels74510853tassels
theirself1551263theirself
thyself1643033thyself
tinsel639443tinsel_
tinsels738373tinsels
vessel937953vessel_
vessels1035933vessels
wisely122711713wi_sely
wissed104114643wisse_d
wisses94619603wisse_s

Search took 9 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.406440125.6
2DLD Change Limit1340271018.14316459.2
3Display Results1011010.0462195.7
 (SQL Overall)1786911018.59520790.1
 
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.