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

337 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
drogues939839(None) 
brogues10719821brogues
drogue8938331drogue_
rogues74617671_rogues
argues74516412ar_gues
brogue94211032brogue_
dengues938182dengues
doges75630162d_og_es
dogies85022252d_ogies
dragees9359482dragees
drones75023432dro_nes
drosses84513822drosses
drouks1137122dro_uks
droves105116672dro_ves
drowses114610232drowses
morgues1038272morgues
pirogues1135472pirogues
rogue66417532_rogue_
rogued84711472_rogued
roques154912562_roques
roues56039352_ro_ues
rouges76022382_rouges
togues76014242_togues
vogues104011922_vogues
agues64919053__agues
apogees1037103apogees
argles75218483ar_gles
argue64818443ar_gue_
argued84311173ar_gued
arguer74510543ar_guer
arguers8489033ar_guers
argus66716543ar_gu_s
arguses84711743ar_guses
arouse65019983aro_use
arouses74921293arouses
baroques1934863baroques
bogies94724313_bogies
bogles95020833_bogles
bogus85616473_bogu_s
boogies103719013boogies
brogans1049663brogans
broguery1443313broguery
broguish1444103broguish
bromes104719763bro_mes
bronzes183510403bronzes
broses86524403bro_ses
browses124712693browses
cangues10611823cangues
cloques18268563cloques
crocus104813173crocu_s
crocuses1239023crocuses
crones84729243cro_nes
cronies9622503cronies
croquet1859683croquet
croquets1955213croquets
croquis1834763croquis
crores86121163cro_res
crosses94220793crosses
croupes114613103croupes
croups104312553cro_ups
crouse84619363cro_use
croutes94815653croutes
crozes174417663cro_zes
daggles103611913daggles
dagoes85714603d_agoes
dangles93618423dangles
degums10438623d_egums
deluges9169263deluges
dengue838253dengue_
derogates11310973derogates
dholes104914793dho_les
dialogues1144813dialogues
dinges83825423ding_es
dingies93618243dingies
dingles93818323dingles
dingoes94114833dingoes
dingus83611843dingu_s
dinguses1037643dinguses
diodes83915783dio_des
dirges84915103dirg_es
dobies94422093d_obies
dodges96119073d_odges
dodoes85716103d_odoes
does56554473d_o__es
doge66233803d_og_e_
dogey105719513d_og_ey
dogeys115510663d_ogeys
dogged106017703d_ogged
dogger95216783d_ogger
doggers104413433d_oggers
doggies103613023doggies
dogie75222793d_ogie_
dogleg936323d_ogleg
doglegs1034783d_oglegs
dogmas105011243d_ogmas
dogs66440153d_og__s
doles67843753d_o_les
domes85735563d_o_mes
donees74519493d_onees
dongles93212873dongles
donuts7410583d_onuts
doobies103915673doobies
doodies94218773doodies
doodles93614163doodles
doofus1036163doofu_s
doofuses1244283doofuses
doolees83711613doolees
doolies83920713doolies
doozies173812723doozies
dopes84935043d_o_pes
dorbugs1132983dorbugs
dories75232363d_ories
doses65938503d_o_ses
dosses76126273d_osses
dotes65836693d_o_tes
doughs115912933d_oughs
doums85417643d_o_ums
douse66329723d_o_use
douses74928933d_ouses
doves94728153d_o_ves
dowses105718303d_owses
doxies143917853d_oxies
dozes155226303d_o_zes
dragee84415603drag_ee
dragged11379563dragged
dragger10309173dragger
draggers11357393draggers
draggles1145963draggles
dragnet91211433dragnet
dragnets10136563dragnets
dragons938383dragons
drags75521113drag__s
drakes114715863dr_akes
drapes95419653dr_apes
drawees11378363drawees
dredges10379343dredges
drees65628523dr__ees
dregs76114863dreg__s
dresses83716173dresses
dries64733673dr__ies
drives105117113dr_ives
droids84712583dro_ids
droits74314313dro_its
drolled93810223drolled
droller84110283droller
drollest937353drollest
drolls75312393dro_lls
dromons1038193dromons
drone65324983dro_ne_
droned84616863dro_ned
droner74717673dro_ner
droners84114383droners
drongos935493drongos
drooled9369203drooled
drools74412813dro_ols
drooped11368433drooped
droops95110963dro_ops
droplet10312113droplet
droplets1136063droplets
dropouts1145003dropouts
dropped13329283dropped
dropper12329873dropper
droppers13318603droppers
drops85719503dro__ps
dropsies1138693dropsies
droskies13186343droskies
dross65418093dro__ss
drought12258873drought
droughts13245733droughts
drouk1039433dro_u_k
drouked1335543drouked
drouth104410103dro_uth
drouths11436483drouths
drove95518063dro_ve_
droved114611643dro_ved
drover104614593dro_ver
drovers115212643drovers
drownds12346153drownds
drowned12419903drowned
drowner11369803drowner
drowners12428273drowners
drowns105612333dro_wns
drowse105010553drowse_
drowsed12448743drowsed
drubs85913833dr__ubs
drudges10308873drudges
drugged11367173drugged
drugget10337613drugget
druggets11313913druggets
druggies11126223druggies
drugs75214653dr__ugs
drums85415873dr__ums
drupes94912653dr_upes
druse64817663dr__use
druses75517253dr_uses
dryades12395633dryades
dues56045503d___ues
dugouts935043dugouts
duologues1143393duologues
eclogues1144573eclogues
erodes74819883ero_des
eroses65327053ero_ses
fogies104118063_fogies
forges105024263forg_es
forgoes11311353forgoes
friges104116483frig_es
froes86126693fro__es
frogeyes1543743frogeyes
frogged13408493frogged
froglet11310063froglet
froglets1235263froglets
frogmen1335893frogmen
frogs96220773frog__s
frontes104214163frontes
fugues104511683_fugues
gangues9149753gangues
garigues1034953garigues
gigues8129003_gigues
gorges85321893gorg_es
gouges86318693_gouges
grogs76319413grog__s
grooves11368803grooves
gropes95220403gro_pes
grosses84517683grosses
groups94210513gro_ups
grouse74315023gro_use
grouses84616543grouses
grouts75015613gro_uts
groves104318103gro_ves
groynes1137823groynes
grues65721963gr__ues
irones64724013iro_nes
ironies7517423ironies
langues81211913langues
leagues837943leagues
loges66534203_log_es
moguls948553_moguls
morgue938113morgue_
moues75732843_mo_ues
noogies82814583noogies
ogees65119143__ogees
ogles65223183__ogles
ogres65818633__ogres
ologies8615023ologies
orgies72316093or_gies
orgones81010793orgones
oroides8311973oroides
pirogies1139423pirogies
pirogue1045413pirogue_
piroques1944353piroques
plagues103311063plagues
pogies94123543_pogies
porgies103017003porgies
prevues1239263prevues
probes104119453pro_bes
procures1239213procures
produces1347903produces
profuse1237153profuse
progged12409793progged
progger11319373progger
proggers12258163proggers
progress1137023progress
progs86624153prog__s
progun968783progu_n
proles84627203pro_les
prologues1246903prologues
prorogues1244883prorogues
proses84733473pro_ses
prosses94019513prosses
proteus92511593proteus
proves114322253pro_ves
proxies163014933proxies
ragees74618663_ragees
rages64539443_rag_es
reges65628783_reg_es
reglues838713_reglues
revues9813903_revues
robes75133303_ro_bes
robles85321693_robles
rodes614039083_ro_des
roes45954133_ro__es
roger64521413_rog_er
rogers74517913_rogers
roguery1134893_roguery
roguish1156833_roguish
roles56747983_ro_les
rooses65526233_rooses
ropes75940063_ro_pes
roque144812133_roque_
roquet154415893_roquet
roquets16398943_roquets
roses56445773_ro_ses
rotes56143903_ro_tes
rotguts833763_rotguts
rottes64524833_rottes
roue45941743_ro_ue_
rouen54920903_ro_uen
rouens64814443_ro_uens
rouge65423443_rouge_
rouged86717323_rouged
roughs105416213_roughs
roups75118903_ro_ups
rouse56634703_ro_use
rouses65436283_rouses
routes66129313_routes
routs57133413_ro_uts
roves84834483_ro_ves
rues46044483_r__ues
scrouges1136683scrouges
segues7412073_segues
shoguns1134413shoguns
stogies8413693stogies
togue64816303_togue_
tongues879693tongues
toques154612353_toques
torques16217513torques
tragus749233tragu_s
troches123715343troches
trogons83410723trogons
trogs67022603trog__s
trokes104019263tro_kes
trompes114111623trompes
trones65629283tro_nes
tropes84824353tro_pes
troughs11698683troughs
troupes94112853troupes
trouts66116633tro_uts
troves94719113tro_ves
trues54925323tr__ues
ungues7412123_ungues
urges64619913ur_g_es
vogue95613043_vogue_
vogued11457633_vogued
voguer10468403_voguer
voguers11356693_voguers
vrouws12494743vro_uws
yogees10510633_yogees

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.1601116818.8
2DLD Change Limit1340273375.85622887.1
3Display Results3373370.1103063.6
 (SQL Overall)1786913376.12629169.3
 
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.