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

186 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
roguery113489(None) 
broguery1443311broguery
doggery13448262doggery
groggery1433512groggery
robbery14348282robbery
rockery16439252rockery
roger64521412rog_er_
rogers74517912rog_ers
rogue66417532rogue__
rogued84711472rogue_d
rogues74617672rogue_s
rookery14398312rookery
ropery114313872ro_pery
rosery93813282ro_sery
toggery12505922toggery
voguer10468402voguer_
voguers11356692voguers
arguer74510543arguer_
arguers8489033arguers
augury10366663augu_ry
bobbery13438353bobbery
bogey115220233bog_e_y
bogusly1343893bogusly
bootery1238983bootery
bowery146012113bo_wery
brogue94211033brogue__
brogues10719823brogue_s
broidery14356083broidery
buggery14367933buggery
cookery164210393cookery
coopery143910273coopery
coppery16409393coppery
coquetry2243563coquetry
crockery19356603crockery
crookery17415993crookery
doddery13516853doddery
dodgery13627783dodgery
dogberry1542863dogberry
dogey105719513dog_e_y
dogger95216783dogger_
doggers104413433doggers
dowery134311663do_wery
drogue8938333drogue__
drogues9398393drogue_s
drollery12314793drollery
fogey125617873fog_e_y
fogger114414783fogger_
foggers124112013foggers
foolery1336693foolery
foppery17385623foppery
forgery14419303forgery
gouger86014363gouger_
gougers94911763gougers
grocery13336763gro_cery
gurry94515413__gurry
hogger114615083hogger_
hoggers124512483hoggers
hosiery13337183hosiery
jaggery19336903jaggery
jobbery21366013jobbery
jogger154713163jogger_
joggers164110693joggers
joinery17366593joinery
logger86420003logger_
loggers94616133loggers
logier75015733logier_
lottery10389833lottery
loury85716753lo_u_ry
lowery124112713lo_wery
maguey1236833mague_y
mockery18376913mockery
monkery16317453monkery
mopery135210973mo_pery
mothery153710513mothery
ochery14319443_ochery
ogler65917443_ogler_
oglers74313183_oglers
onery8414123_o_nery
oogeny10117923oog_eny
ornery938463_ornery
orogeny11107023orog_eny
orrery936783_orrery
piggery14266193piggery
pogey116017893pog_e_y
popery134511703po_pery
pottery123011073pottery
powdery16396123powdery
priggery1543993priggery
progeny1389463prog_eny
progger11319373progger_
proggers12258163proggers
query174212083__query
raggedy13334663raggedy
rebury11349213rebu_ry
revery124014213r_every
riflery13345803riflery
rigger85616713rigger_
riggers93613843riggers
roamer84715163roamer_
roamers93713463roamers
roarer63914333roarer_
roarers73812743roarers
robber103916533robber_
robbers112814163robbers
robotry1244173robotry
rocker124319573rocker_
rockers133916553rockers
rocketry1744503rocketry
rogatory1246153rogatory
rogered939553rog_ered
rogueing1054313rogueing
rogueries1047003rogueries
roguing9309563roguing
roguish1156833roguish
rolfer94412273rolfer_
rolfers104011813rolfers
roller63919793roller_
rollers73117473rollers
romper104213683romper_
rompers113412243rompers
roofer94415283roofer_
roofers105013903roofers
roomer84718633roomer_
roomers95416413roomers
rooser63921883rooser_
roosers74217883roosers
rooter64926033rooter_
rooters74522933rooters
roper75431913ro_per_
ropers84325903ro_pers
ropey106021873ro_pe_y
ropier84118803ropier_
roque144812133roque__
roques154912563roque_s
roquet154415893roque_t
roquets16398943roquets
rosary92810353ro_sary
rosier64221263rosier_
roster64329083roster_
rosters73727543rosters
rotary92411303ro_tary
rotter64325463rotter_
rotters74421393rotters
roue45941743ro_ue__
rouen54920903ro_ue_n
rouens64814443ro_uens
roues56039353ro_ue_s
rouge65423443rouge__
rouged86717323rouge_d
rouges76022383rouge_s
roughdry1692543roughdry
rougher113511033rougher_
roughers12329183roughers
roughly14507293roughly
roughy137010863ro_ughy
roupy106112713ro_u_py
rouser65224083rouser_
rousers75220143rousers
router65025843router_
routers74822873routers
rover85527373ro_ver_
rovers95423523ro_vers
rower85430493ro_wer_
rowers94924573ro_wers
rozzer1437353rozzer_
rozzers1535633rozzers
rubbery14337593rubbery
rudery10419033r_udery
ruer46127563r__uer_
ruers515019413r__uers
rugger84414513rugger_
ruggers94612313ruggers
sorcery1237033sorcery
togue64816303togue__
togues76014243togue_s
tottery10388483tottery
towery124012093to_wery
vaguely1443693vaguely
vaguer10448443vaguer_
vogue95613043vogue__
vogued11457633vogue_d
vogues104011923vogue_s
volery1237873vo_lery
waggery15276903waggery
wiggery15295873wiggery
yogurt1037823yogu_rt

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.406440125.6
2DLD Change Limit1340271865.97022450.1
3Display Results1861860.0603100.0
 (SQL Overall)1786911866.43627764.3
 
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.