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

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

71 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
recuse8551916(None) 
recluse95210771recluse
recused104714421recused
recuses94619461recuses
refuse94817511refuse
retuse66617221retuse
reuse56025361re_use
accuse103411032accuse
because1136232because
becurse1136182becurse
bemuse1038942bemuse
ceruse83914522ceruse
defuse105712722defuse
ecus65421462_ecus_
excuse1537422excuse
incuse83513572incuse
peruse84016842peruse
precise113518172precise
precure11312552precure
reaccuse1245042reaccuse
rebuke124010122rebuke
rebus75721112rebus_
rebuses94915292rebuses
recane83022872recane
recast83422772recast
recce9514562rec_ce
recces10614912recces
recede95515532recede
recess8314262recess
rechose121312042rechose
recipe103414892recipe
recite83625112recite
recks115625132recks_
recluses105111732recluses
recode93618712recode
recoupe11109932recoupe
recourse1038382recourse
recs65734182rec_s_
rectus83314632rectus_
recur74116842recu_r
recurs83315802recurs
recurve1237402recurve
recusal968672recusal
recut74729242recu_t
recuts83817372recuts
reduce9713252reduce
refuge105312612refuge
refused115114442refused
refuser104912782refuser
refuses104918552refuses
refute95515702refute
rehouse10311772rehouse
relume8313272relume
remise84221952remise
repose84121412repose
repulse938192repulse
repute84716092repute
rerise64325632rerise
rerose63320842rerose
rescue8313002rescu_e
rescues9312752rescues
resume8313782resume
retune69121952retune
reused75419562re_used
reuses66025522re_uses
revise94019742revise
revue81114452revu_e
revues9813902revues
rouse56634702r_ouse
ruse45938932r__use
secure8513532secure

Search took 3 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 Filter178691825510.1101624463.6
2DLD Change Limit82551712.75030018.5
3Display Results71710.0302366.7
 (SQL Overall)178691712.89061830.8
 
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.