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

86 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
hocussed1415379(None) 
focussed14174041focussed
hocused13167011hocu_sed
hocusses13155301hocusses
chorussed1543212chorussed
concussed1444752concussed
cussed94917122__cussed
focused13166412focu_sed
focusses13155222focusses
hocuses121710422hocu_ses
housed105624102ho_u_sed
moussed10338912mo_ussed
accessed1385403accessed
accursed1354633accursed
accused12368423accu_sed
becursed1335583becursed
bossed94816533bo__ssed
boused95322883bo_u_sed
bussed94717053__bussed
caucussed1441913caucussed
cessed94615613__cessed
chorused1446133choru_sed
chorusses1444883chorusses
choused135012463cho_u_sed
concusses1346343concusses
coursed104113603co_ursed
cursed94321253__cursed
cusped114312043__cusped
cusser86016093__cusser
cusses84522773__cusses
defocussed17152373defocussed
discussed13256753discussed
dossed84516633do__ssed
doused84821163do_u_sed
excessed1844943excessed
excused1736293excu_sed
focuser12155783focu_ser
focuses12159653focu_ses
fussed104613803__fussed
harassed1237113harassed
hissed104114453h__issed
hocked165521303hoc__ked
hocus104715203hocu_s__
hocusing1446583hocusing
hocussing1544093hocussing
hoised105117433ho__ised
hoisted113411293ho_isted
horsed105321083ho__rsed
hosed95830983ho___sed
hosted105020343ho__sted
hostessed1344353hostessed
hounded123311033ho_unded
house89131423ho_u_se_
housel95217043ho_u_sel
houseled1237283ho_useled
houser95322283ho_u_ser
houses96032273ho_u_ses
hushed134416673h__ushed
husked144212223h__usked
incused102911173incu_sed
jousted15339143jo_usted
loculed10317653locu_led
loused74822913lo_u_sed
mossed94818893mo__ssed
moused94423303mo_u_sed
mousse84813033mo_usse_
mousses94012703mo_usses
mussed94418903__mussed
ousted73720583_o_usted
percussed1444793percussed
processed1446803processed
recessed1139713recessed
recused104714423recu_sed
refocussed16102913refocussed
roused75426443ro_u_sed
rousted84013323ro_usted
schussed1443053schussed
soused74822983so_u_sed
succussed1443393succussed
sussed75015533__sussed
tossed74215223to__ssed
toused74122013to_u_sed
tousled84710363to_usled
trussed84010013_trussed
uncursed1148963uncursed
unfocussed1642083unfocussed

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 Filter1786911461620.1531167915.0
2DLD Change Limit146162868.20617811.6
3Display Results86860.0302866.7
 (SQL Overall)178691868.38921300.6
 
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.