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

120 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
hocusses1315530(None) 
focusses13155221focusses
hocuses121710421hocu_ses
hocussed14153791hocussed
chorusses1444882chorusses
concusses1346342concusses
cusses84522772__cusses
focuses12159652focu_ses
focussed14174042focussed
hocused13167012hocu_sed
houses96032272ho_u_ses
mousses94012702mo_usses
accesses1287493accesses
accuses114112193accu_ses
arcuses94814693arcu_ses
becurses1236723becurses
boluses94113833bolu_ses
bonuses94212953bonu_ses
bosses85925403bo__sses
bourses94014303bo_urses
bouses84931783bo_u_ses
busses85023383__busses
caucusses1343043caucusses
cesses84221363__cesses
chausses1345963chausses
choruses1339983choru_ses
chorussed1543213chorussed
chouses125117813cho_u_ses
choushes1637623cho_ushes
concussed1444753concussed
courses94218893co_urses
crocuses1239023crocu_ses
cuisses9319883__cuisses
curses85328273__curses
cussed94917123__cussed
cusser86016093__cusser
cussers94213393__cussers
cussos84210003__cussos
defocusses16152843defocusses
discusses12268233discusses
dosses76126273do__sses
douses74928933do_u_ses
excesses1736753excesses
excuses1638903excu_ses
ficuses12159203ficu_ses
focused13166413focu_sed
focuser12155783focu_ser
focusers13134373focusers
focusless1452263focusless
fosses96022083fo__sses
fucuses12158353fucu_ses
fusses94920553__fusses
gausses8308693_gausses
harasses11311033harasses
hisses94719353h__isses
hocus104715203hocu___s
hocusing1446583hocusing
hocussing1544093hocussing
hognoses12108133hognoses
hoises94823673ho__ises
hommoses1538153hommoses
horses94729343ho__rses
horstes104516113ho_rstes
hoses85443173ho___ses
hostesses1247173hostesses
hotnesses1238903hotnesses
house89131423ho_u_se_
housed105624103ho_u_sed
housel95217043ho_u_sel
housels105312133ho_usels
houser95322283ho_u_ser
housers104717813ho_users
humuses1237593humu_ses
hushes124718593h__ushes
hussies103213293h__ussies
incuses93514853incu_ses
josses135117683jo__sses
koussos11373903ko_ussos
locules92812603locu_les
locusts9277933locu_sts
loesses7310033lo_esses
losses65925233lo__sses
lotuses74011253lotu_ses
louses66230283lo_u_ses
molasses1037233molasses
momuses1159263momu_ses
morasses1038903morasses
mosses85527683mo__sses
mouses85531423mo_u_ses
mousse84813033mo_usse_
moussed10338913mo_ussed
mucuses11148513mucu_ses
musses84624783__musses
nonuses73313863nonu_ses
nouses64627163no_u_ses
onuses65616253_onu_ses
opuses84012243_opu_ses
oyesses1037333_oyesses
percusses1346503percusses
plusses93510693_plusses
posses85128803po__sses
poussies1038113po_ussies
processes13310233processes
pusses84322843__pusses
recesses10312323recesses
recuses94619463recu_ses
refocusses15163473refocusses
rouses65436283ro_u_ses
schusses1334213schusses
scouses93313243scou_ses
souses64229243so_u_ses
succusses1344423succusses
susses64221053__susses
tonuses73612193tonu_ses
tosses65225393to__sses
touses64229673to_u_ses
tousles74113933to_usles
trusses73813633_trusses
tusses64921243__tusses
wusses93314893__wusses

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 Filter1786911461620.1731032896.0
2DLD Change Limit1461621207.31019994.8
3Display Results1201200.0502400.0
 (SQL Overall)1786911207.53323721.1
 
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.