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

40 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
caucusses134304(None) 
caucuses1236781caucu_ses
caucussed1441911caucussed
carcasses1337472carcasses
caucused1344092caucu_sed
concusses1346342concusses
accesses1287493_accesses
accuses114112193_accu_ses
arcuses94814693_arcu_ses
cactuses1237933ca_ctuses
calculuses1443193calculuses
calluses1039323callu_ses
camasses12388973ca_masses
campuses1437773campu_ses
canvasses14286033canvasses
carcases12313083carc_ases
caresses10314063ca_resses
carouses10614503carou_ses
caucus1039613caucu___s
caucusing1443803caucusing
caucussing1542583caucussing
causes88026473ca__u_ses
cayuses12188403ca_yu_ses
chausses1345963c_hausses
chorusses1444883chorusses
circuses1238253circu_ses
concussed1444753concussed
coulisses1145633coulisses
crocuses1239023crocu_ses
cuisses9319883c_u_isses
cuscuses1235863cuscu_ses
cusses84522773___cusses
discusses12268253discusses
focusses13155223_focusses
fucuses12158353_fucu_ses
gausses8308693ga__usses
hocusses13155303_hocusses
mucuses11148513_mucu_ses
percusses1346503percusses
succusses1344423succusses

Search took 7 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 Filter1786911486410.403443402.0
2DLD Change Limit148641406.20623951.2
3Display Results40400.0133076.9
 (SQL Overall)178691406.62226984.4
 
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.