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

172 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
scourge103565(None) 
scourged1234571scourged
scourger1134721scourger
scourges1136531scourges
courage10310992_courage
course85117782_course
score75526742sco_r_e
scour75315532scour__
scoured103811152scoured
scourer93910432scourer
scourgers1234382scourgers
scours84913592scour_s
scouse84113632scou_se
scrouge1036352scrou_ge
scrounge1143912scrounge
source8410672s_ource
splurge1044762splurge
spurge93711322s_purge
stoure64814942stour_e
stourie7469352stourie
surge65027692s__urge
bourg84113843_bourg_
bourgs9459993_bourgs
bourne83714093_bourne
bourse84414333_bourse
charge125114213_charge
coarse84813903_coarse
coerce10310403_coerce
colure8314163_colur_e
conge85227593_co_nge
core67263113_co_r_e
corgi8316083_co_rgi
corrie83621223_corrie
corse75036183_co_rse
coude85022633_cou_de
cough115819643_cou_gh
coulee8323513_coulee
coupe96023483_cou_pe
couple104415963_couple
courages11311393_courages
courier93617893_courier
coursed104113603_coursed
courser94114803_courser
courses94218893_courses
court75532773_cour_t
courted103514923_courted
courter94516483_courter
courts84216173_courts
cowage12310673_cowage
cowrie113814283_cowrie
cure66149123_c_ur_e
curie74533043_c_urie
curse75829143_c_urse
curve104920023_c_urve
discourage1454623discourage
discourse1246863discourse
ecotage1036883ecotage
encourage1244153encourage
escuage1035113esc_uage
forge95126943_fo_rge
gorge76423893_go_rge
gouge78220063_gou_ge
gourde8107933_gourde
gurge75419783__gurge
lounge75211213_lounge
ourie54027303__ourie
purge85324603__purge
recourse1038383recourse
resurge839073resurge
rouge65423443_rou_ge
sarge65531133s__arge
scalage103110533scalage
scarce104013633sc_arce
scare75334463sc_ar_e
scaur75814903scaur__
scaurs85512053scaur_s
sciurid1044923sciurid
sciurine1045233sciurine
sclerae937933sclerae
sconce104711723sco_nce
scone74621833sco__ne
scope94821483sco__pe
scopulae1254613scopulae
scorch13198093sco_rch
scored94621133sco_red
scorer84818263sco_rer
scores84725923sco_res
scoria8513503sco_ria
scoriae9310903scoriae
scorn75817453sco_r_n
scorned10229953sco_rned
scorner9259763sco_rner
scorns85713023sco_rns
scottie937463scottie
scourers10348533scourers
scourging1334573scourging
scouring112810853scouring
scourings12235293scourings
scouses93313243scouses
scout75031453scou__t
scouted104112033scouted
scouter93313323scouter
scouth115011153scou_th
scouther1356943scouther
scouths12527893scouths
scouts84817943scou_ts
scree720031713sc__ree
scrooge1037183scrooge
scrouged1235383scrou_ged
scrouges1136683scrou_ges
scrounged1343143scrounged
scrounger1243443scrounger
scrounges1243923scrounges
scroungy1452563scroungy
scruple1137193scruple
scurf104719323sc_ur_f
scurfs113210813sc_urfs
scurfy14338763sc_urfy
scurry11419593sc_urry
scurvy14386103sc_urvy
scutage1036333scutage
scute75520943sc_u_te
secure8513533secur_e
serge64727473s__erge
shore85432653sho_r_e
slough10539233slou_gh
sludge84811943s_ludge
smudge10387913s_mudge
snore55424953sno_r_e
socage91012123s_ocage
soccage1236283soccage
soiree62919483s_oiree
sore47059533s_o_r_e
sorgo64719723s_o_rgo
sough95320463s_ou_gh
sour45935893s_our__
sourced1038453s_ourced
sources9312173s_ources
soured74921863s_oured
sourer63620213s_ourer
sourly93612213s_ourly
sours55230503s_our_s
souse56530773s_ou_se
sparge94216053s_parge
splurged1243923splurged
splurger1143813splurger
splurges1145163splurges
splurgy1343023splurgy
sponge939663spo_nge
spore75428593spo_r_e
sporule937273sporule
spouse84112513spou_se
spurges104111653s_purges
stodge8369043sto_dge
stooge73811663sto_oge
storage8310473storage
store56333813sto_r_e
stour54916743stour__
stoures74614163stoures
stours65015633stour_s
stoury9529943stour_y
stowage1136703stowage
sure45447413s__ur_e
surged84118883s__urged
surger74320093s__urger
surges73924593s__urges
surgy95118523s__urgy
suture6313203sutur_e
swore84920823swo_r_e
synurae1044253synurae
upsurge10134333upsurge
urge54722423___urge

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 Filter1786911340270.393454684.5
2DLD Change Limit1340271726.36021073.4
3Display Results1721720.0602866.7
 (SQL Overall)1786911726.81326227.9
 
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.