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

165 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
scrouge103635(None) 
scrooge1037171scrooge
scrouged1235371scrouged
scrouges1136681scrouges
scrounge1143911scrounge
croupe105114432_croupe
crouse84619362_crouse
croute84617272_croute
rouge65423442__rouge
scourge1035652sc_ourge
scouse84113632sc_ouse
scroggy14243842scroggy
scrooges1137162scrooges
scrounged1343132scrounged
scrounger1243442scrounger
scrounges1243922scrounges
scroungy1452562scroungy
acreage1037833acreage
acrogen1038193acro_gen
arouse65019983_arouse
berouged1235323berouged
borough1344513borough
brogue94211033_brogue
carouse9614423carouse
chough15699243_chough
chouse116017563_chouse
clough12539133_clough
conge85227593_c_onge
coude85022633_c_oude
cough115819643_c_ough
coupe96023483_c_oupe
cringe93515483_cringe
crone75231333_cro_ne
crore74922863_cro_re
crosse85216303_crosse
crouch133910203_crouch
croup95616783_crou_p
croupes114613103_croupes
croups104312553_croups
croupy13458733_croupy
croutes94815643_croutes
croze164719453_cro_ze
crude86018573_cr_ude
cruse75726103_cr_use
drogue8938333_drogue
eclogue1044503eclogue
gouge78220063__gouge
grouse74315023_grouse
pirogue1045413pirogue
reroute7313963reroute
rogue66417533__rogue
roue45941743__rou_e
rouged86717323__rouged
rouges76022383__rouges
rough97819433__rough
rouse56634703__rouse
route55132073__route
sarge65531133sar__ge
sarode75317513saro_de
sarong73914873sarong_
sarongs84511803sarongs
scalage103110533scalage
sconce104711713sc_once
scone74621833sc_o_ne
scope94821483sc_o_pe
score75526733sc_o_re
scoriae9310893scoriae
scour75315533sc_ou_r
scoured103811153sc_oured
scourer93910433sc_ourer
scourged1234573sc_ourged
scourger1134723sc_ourger
scourges1136533sc_ourges
scours84913583sc_ours
scouses93313243sc_ouses
scout75031453sc_ou_t
scouted104112033sc_outed
scouter93313323sc_outer
scouth115011153sc_outh
scouts84817943sc_outs
scrag85916173scr_ag_
scragged1335813scragged
scraggy14304583scraggy
scrags95713803scr_ags
scraigh1335673scraigh
scrape105917573scr_ape
scrapie115010943scrapie
scree720031703scr__ee
scribe104613523scr_ibe
scrieve12448333scrieve
scrive115414943scr_ive
scrod85115063scro__d
scrods94111603scro_ds
scrofula1363383scrofula
scroggier1343133scroggier
scroll8310163scro_ll
scrolled1137043scrolled
scrolls938063scrolls
scrooch1444953scrooch
scroop10299773scro_op
scrooped1356403scrooped
scroops11288243scroops
scrota8310183scro_ta
scrotal938483scrotal
scrotum1145103scrotum
scrotums1243963scrotums
scrouging1335263scrouging
scroungers1343183scroungers
scroungier1341963scroungier
scrub94914203scr_u_b
scrubs104210313scr_ubs
scruff1437963scr_uff
scrum95418193scr_u_m
scrums104614253scr_ums
scruple1137193scruple
scutage1036333scutage
scute75520943sc__ute
serfage1138403serfage
serge64727463ser__ge
serosae7310243serosae
serous65023553serou_s
shroud1038763shrou_d
shrouded1333593shrouded
shrouds1136013shrouds
shrove125412223shro_ve
shrug94512513shr_ug_
shrugs10469163shr_ugs
slough10539233s_lough
soroche1237183soroche
sough95320463s__ough
souse56530773s__ouse
splodge1134103splodge
sponge939663s_ponge
sporule937273sporule
spouse84112513s_pouse
springe103913983springe
sprout8419403sprou_t
sprouted1136383sprouted
sprouts949983sprouts
spruce103910873spr_uce
sprue74717633spr_u_e
sprug85313893spr_ug_
sprugs94010173spr_ugs
stodge8369043s_todge
stooge73811663s_tooge
storage8310473storage
stoure64814943s_toure
strange85416343strange
strobe84513813stro_be
strode75215973stro_de
stroke105116173stro_ke
strong74914883strong_
stronger9349683stronger
strophe1239133strophe
stroud7310383strou_d
strouds837793strouds
strove95014793stro_ve
sucrose939303sucro_se
surge65027693sur__ge
syringe11349473syringe
through141647513through
trough108512023_trough
troupe84812433_troupe
unrough11105233unrough
uprouse937223uprouse

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 Filter1786911340270.1731032896.0
2DLD Change Limit1340271657.51617832.2
3Display Results1651650.0602750.0
 (SQL Overall)1786911657.74923059.9
 
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.