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

139 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
recourse103838(None) 
recourses1137731recourses
becurse1136182bec_urse
course85117782__course
racecourse1451632racecourse
recluse95210772reclu_se
recoupe11109932recou_pe
recouple12107122recouple
recoups1188842recoups_
recurs83315802rec_urs_
recurve1237402rec_urve
recuse85519162rec_u_se
rehouse10311772rehou_se
remorse9311712remo_rse
repours9310232repours_
repousse1046052repousse
resource1046312resource
because1136233becau_se
becursed1335593bec_ursed
becurses1236723bec_urses
becurst1147853bec_urst
bescours1245093bescours_
bourse84414333__bourse
coarse84813903__coarse
concourse1345803concourse
corse75036183__co_rse
coursed104113603__coursed
courser94114803__courser
courses94218893__courses
curse75829143__c_urse
decors94017773deco_rs_
decouple13114873decouple
decurve1335583dec_urve
delouse839833delou_se
detours858043detours_
devours1166643devours_
discourse1246863discourse
lecture9149523lectur_e
lectures101310163lectures
midcourse1442223midcourse
nonrecourse1352303nonrecourse
precure11312553prec_ur_e
precures12312903prec_ures
premorse1237553premo_rse
racecourses1551653racecourses
rancours1076713rancours_
reaccuse1245043reaccu_se
rearouse839383rearou_se
rebore86625653rebo_r_e
rebores95319163rebo_res
recharge1476613recharge
rechoose13137353rechoose
rechose121312053rec_hose
recluses105111733reclu_ses
recoals94214633recoals_
recoats92616653recoats_
recocks154711463recocks_
recode93618713reco__de
recodes102918633recodes_
recognise1245303recognise
recoils93814873recoils_
recoins94019243recoins_
recolors1078813recolors_
recombs1336753recombs_
recompose1545293recompose
recons84922993reco_ns_
recooks134711233recooks_
recopies12313743recopies
record96117433reco_r_d
recorded122511073reco_rded
recorder11249633reco_rder
records105213923reco_rds
recork126315493reco_r_k
recorked15239863reco_rked
recorks134813023reco_rks
recount9315173recou_nt
recounted1238723recounted
recounter1137943recounter
recounts1038773recounts
recoup10810373recou__p
recouped13128673recouped
recoupled1496173recoupled
recouples13116823recouples
recovers133511123recovers_
rectors93520523rectors_
rectums11338523rectums_
rectus83314633rectu_s_
recur74116843rec_ur__
recurred1137093rec_urred
recursive1445453rec_ursive
recurved1436493rec_urved
recurves1337403rec_urves
recused104714433rec_u_sed
recuses94619463rec_u_ses
recuts83817373rec_uts_
redhorse1245463redhorse
redouble1145523redouble
redouts81411663redouts_
reforge11259033refo_rge
refuse94817513re_fu_se
regorge9257833rego_rge
rehearse11296663rehearse
rehoused1239623rehou_sed
rehouses11312113rehou_ses
reimburse1342263reimburse
remorses10311993remo_rses
renounce1047403renounce
reoccurs1242963reoccurs_
repose84121413repo__se
repour8310993repour__
repoured1139563repoured
repousses1146063repousses
repulse938193re_pulse
repursue1044033re_pursue
rerose63320853rero__se
reroute7313963rerou_te
reroutes8312223reroutes
rescore95616203resco_r_e
rescores105415693resco_res
resources1146203resources
resurge839073re_surge
retore67630773reto_r_e
retrorse837633retrorse
retrousse944623retrousse
retuse66617223re_tu_se
reuse56025363re__u_se
reverse103913743re_verse
rewore938030163rewo_r_e
rigours8207003rigours_
rouse56634703r__ou_se
rumours976373rumours_
scourge1035653_scourge
scours84913593_scours_
scouse84113633_scou_se
secure8513533sec_ur_e
secures9613163sec_ures
telecourse1252333telecourse
tenours72610073tenours_
velours10278083velours_

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.406440125.6
2DLD Change Limit1461621397.78318779.6
3Display Results1391390.0602316.7
 (SQL Overall)1786911398.24921662.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.