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

94 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
schussed144305(None) 
schusser1342971schusser
schusses1334211schusses
chassed134712132_chassed
cussed94917122_c_ussed
schuss11186732schuss__
schussers1442542schussers
shushed14348492s_hushed
succussed1443392succussed
sussed75015532s__ussed
accessed1385403accessed
accursed1354633accursed
accused12368423accu_sed
bussed94717053__bussed
caused95117043_cau_sed
cessed94615613_c_essed
chased125019293_ch_ased
chasmed154710173_chasmed
chasse115114603_chasse_
chasses124017503_chasses
chausses1345963_chausses
cheesed133910683_cheesed
chesses124112633_chesses
chested133811673_chested
chorussed1543213_chorussed
choused135012463_choused
chowsed16478603_chowsed
chucked19469733_chucked
chuffed19316643_chuffed
chugged1584823_chugged
chummed17396443_chummed
chumped17379493_chumped
chunked17428213_chunked
churned13358373_churned
churred13409173_churred
chuted124611843_chu_ted
classed104113653_classed
coursed104113603_coursed
crossed105313893_crossed
cruised103710213_cruised
crushed134111963_crushed
crusted103712753_crusted
cursed94321253_c_ursed
cusped114312043_c_usped
cusser86016093_c_usser
cusses84522773_c_usses
discussed13256753disc_ussed
focussed14174043focussed
fussed104613803__fussed
hissed104114453__hissed
hocussed14153793hocussed
hushed134416673__hushed
husked144212223__husked
moussed10338913_moussed
mussed94418903__mussed
sassed76116173s__assed
schemed1577753sch_emed
schlumped1941953schlumped
schmoosed17294303schmoosed
schooled1447043schooled
schuls11299853schuls__
schussing1542953schussing
scoured103811153scou_red
scourged1234573scourged
scouse84113633scou_se_
scouses93313243scou_ses
scouted104112033scou_ted
scrubbed1533853scrubbed
scrummed1554313scrummed
scrupled1335813scrupled
scubaed1236123sc_ubaed
scudded12215933sc_udded
scuffed16298243sc_uffed
sculked14307183sc_ulked
sculled102911693sc_ulled
sculped12398253sc_ulped
scummed14347913sc_ummed
shucked17389833s_hucked
shunned11417843s_hunned
shunted11339773s_hunted
shusher13288113s_husher
shushes133510303s_hushes
shuted103913163s_hu_ted
slushed113611243s_lushed
smushed13368233s_mushed
soused74822983s_ou_sed
spoused10349653spou_sed
squushed21193703squushed
stressed9128543stressed
succusses1344423succusses
sudsed83911373s__udsed
susses64221053s__usses
trussed84010013_trussed
unhusked1634603unhusked

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.1561145455.1
2DLD Change Limit146162947.61019206.6
3Display Results94940.0432186.0
 (SQL Overall)178691947.80922882.7
 
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.