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 “itself” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

89 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
itself94626(None) 
himself1544282himself
hisself1335912hisself
myself1445592myself
self75138292__self
ainsell796393ainsell
basely114412313basely
delf85436573__delf
diesel74410403diesel_
diesels8429143diesels
easel54521113easel_
easels65914553easels
elf66138523___elf
enserf9310763enserf
fusel85218493fusel_
fusels94412453fusels
herself1337623herself
hirsel9138683hirsel_
hirsels10128343hirsels
hosel86024813hosel_
hosels94218603hosels
impel95711773impel_
impels10389523impels
ingulf10310353ingulf
inseam8329993inseam
insect83916583insect
insert64325253insert
inset54430863inse_t
insets64016133insets
insole63515863insole
insult62813673insult
isle45121703i_s_le
isled64615993i_sled
isles54220563i_sles
islet54527553i_slet
issei568573isse_i
isseis638563isseis
istle52214713i_stle
istles62814983istles
item65620383it_e_m
items7499613it_ems
ither84617603ithe_r
its35538833its___
kittel10368873kittel_
listel64214743listel_
listels74212433listels
lithely1356643lithely
losel54419423losel_
losels64714583losels
missel85216523missel_
missels94614813missels
nonself1078513nonself
oneself1046073oneself
ourself1057453ourself
ousel55222403ousel_
ousels64815273ousels
outsell7109263outsell
pelf97031453__pelf
resell64215203resell
seif75638733__seif
sel38253323__sel_
selfs85220243__selfs
sell45840613__sell
sels46345983__sels
serf76340113__serf
shelf115221113_shelf
steel55721993steel_
steels64117983steels
steely93612573steely
stela54019043st_ela
stele55026843st_ele
tael46030713_tael_
taels56822073_taels
teel46335803_teel_
teels55726373_teels
teff106023763_t_eff
tel35647903_t_el_
tela45532973_t_ela
tele45040873_t_ele
tell44934703_t_ell
tels46841693_t_els
tesla55612603_tesla
thyself1643033thyself
timely113410113timely
tinsel639443tinsel_
tinsels738373tinsels
tref77030993_tre_f
unsell63512543unsell
wisely122711713wisely

Search took 10 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.1261418182.5
2DLD Change Limit112716899.40311987.2
3Display Results89890.0165562.5
 (SQL Overall)178691899.54518720.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.