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

255 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
riflery1334580(None) 
rifler94014261rifler_
riflers103512191riflers
grillery12355502grillery
raillery1134952raillery
ridley10169542ridle_y
rifely123710032rif_ely
rifer84721982rif_er_
riffler13328352riffler_
rifflers14336442rifflers
rifle85518332rifle__
rifled104115002rifle_d
rifles94217702rifle_s
riley84420582ri_le_y
trifler103912152trifler_
triflers113110212triflers
artillery1243573artillery
bibbery13426543bibbery
biflex1834953bifle_x
biller84923483biller_
billers94720833billers
bindery13459833bindery
birler85715083birler_
birlers93813003birlers
bribery14426493bri_bery
bridler103811073bridler_
bridlers11359183bridlers
briery114510773bri__ery
butlery12369423butlery
celery1139623_celery
cindery13429193cindery
cutlery12448393cutlery
cyclery1763493cyclery
diablery1443233diablery
dialer74315433dialer_
dialers83614303dialers
differ133910843differ_
differs14339973differs
dithery14318943dithery
drifter11348703drifter_
drifters12417913drifters
driller84311883driller_
drillers9429723drillers
drollery12314793drollery
faery116015483__faery
fiery114714793__fiery
fifer115519973fif_er_
fifers125414923fif_ers
filer85433003fi_ler_
filers94623723fi_lers
filler94623623filler_
fillers104320213fillers
finery124512893fi_nery
fishery16397733fishery
fleury12417353__fleury
fley106626853__fle_y
foolery1336693foolery
friller104111743friller_
frillers11349873frillers
frippery1832953frippery
fullery13337973fullery
gallery11468743gallery
giller74519733giller_
gillers84216903gillers
gingery12368913gingery
grifter113810493grifter_
grifters12389233grifters
griller84513353griller_
grillers93810813grillers
grindery13255513grindery
hellery13329213hellery
hiller94421633hiller_
hillers103718733hillers
idler65015663_idler_
idlers74012813_idlers
iller54821293_iller_
jittery17346443jittery
killer104917953killer_
killers114215583killers
lifer85822153lif_er_
lifers95617843lif_ers
lifter93814813lifter_
lifters104313783lifters
littery103710493littery
livery124910903li_very
miler75733063mi_ler_
milers84625163mi_lers
miller84625413miller_
millers93621343millers
misery114113543mi_sery
niffer12378443niffer_
niffers13287363niffers
nitery94412173ni_tery
oiler54628283oi_ler_
oilers64721193oi_lers
pedlery13297083pedlery
piggery14266193piggery
pilfer1139163pilfer_
pilfers1238963pilfers
pillory12247453pillory
pinery115214293pi_nery
priggery1543993priggery
printery13318433printery
puffery18235113puffery
raffler13339223raffler_
rafflers14317363rafflers
rafter94517583rafter_
rafters103715633rafters
railer64524933railer_
railers74420663railers
realer63528593realer_
reeler63822573reeler_
reelers73520273reelers
refer84822143ref_er_
refers93921083ref_ers
refinery14447193refinery
reflect123913713reflect
reflet94024233refle_t
reflets103513153reflets
reflew12389453refle_w
reflex16359513refle_x
reflexly2142463reflexly
refly113914563refl__y
refry114412463ref__ry
reifier103414523reifier_
reifiers11309843reifiers
replevy1533473replevy
revelry1335693revelry
revery124014213r_every
ribaldry1441703ribaldry
ribber103515493ribber_
ribbers113913183ribbers
ribier84414233ribier_
ribiers9319753ribiers
ribless93410343ribless
riblet84222443rible_t
riblets93412553riblets
ricer74726613ri_cer_
ricers84120993ri_cers
richer114015043richer_
rickety16478313rickety
rickey154613973ricke_y
ridder84015143ridder_
ridders93612493ridders
riddler93411263riddler_
riddlers10269103riddlers
rider65231303ri_der_
riders74123903ri_ders
ridleys11145783ridleys
riever94811653riever_
rievers104311453rievers
rife74632323rif_e__
rifest93114583rif_est
riffed133811563riffe_d
riffle124210233riffle__
riffled14338603riffle_d
riffles133911163riffle_s
riflebird1551533riflebird
rifleman1343413rifleman
riflemen1344243riflemen
rifleries1247683rifleries
rifling112815013rifling
riflip1134723rifl_ip
riflips1234163riflips
rifted104115313rifte_d
riftless1136943riftless
rigger85616713rigger_
riggers93613843riggers
rile45650533ri_le__
riled65833253ri_le_d
riles55343643ri_le_s
rille55728733rille__
rilled74525653rille_d
rilles64725503rille_s
rillet64828853rille_t
rillets74216153rillets
rimer75429243ri_mer_
rimers84522553ri_mers
rimier83916273rimier_
rimless9369363rimless
rimmer103516033rimmer_
rimmers113812883rimmers
ringer74526063ringer_
ringers83922953ringers
rinser64317213rinser_
rinsers73815743rinsers
rioter64817283rioter_
rioters73615513rioters
ripely112511153ri_pely
riper74328403ri_per_
ripper103518653ripper_
rippers114115033rippers
rippler113210103rippler_
ripplers12337113ripplers
riser55431053ri_ser_
risers64624783ri_sers
risker105414493risker_
riskers114011993riskers
ritter63822423ritter_
ritters74020623ritters
rivalry1354033rivalry
river85731693ri_ver_
rivers94626543ri_vers
riviera1035073riviera
riviere1036373riviere
robbery14348283robbery
rockery16439253rockery
roguery1134893roguery
rolfer94412273rolfer_
rolfers104011813rolfers
roller63919793roller_
rollers73117473rollers
rookery14398313rookery
ropery114313873r_opery
rosery93813283r_osery
rubbery14337593rubbery
rudery10419033r_udery
ruffler13369723ruffler_
rufflers14347193rufflers
ruler54923343r_uler_
rulers64317093r_ulers
sealery104011053sealery
sidler74716963sidler_
sidlers83414233sidlers
sifter94516233sifter_
sifters103714793sifters
siller64026063siller_
sillers73822103sillers
silvery13328093silvery
stifler102911473stifler_
stiflers11238833stiflers
tiler56131023ti_ler_
tilers63523503ti_lers
tiller64222543tiller_
tillers73418743tillers
timbery14256893timbery
tindery11389363tindery
trickery17297343trickery
trifle94012883trifle__
trifled113711963trifle_d
trifles103814823trifle_s
triller74215893triller_
trillers83613493trillers
vilely1239443vi_lely
viler86324163vi_ler_
vinery124912603vi_nery
volery1237873_volery
wafery15398693waf_ery
wifely15429423wif_ely
wifey144913673wif_e_y
wiggery15295873wiggery
willer94021063willer_
willers103517913willers
winery125014283wi_nery
wintery13399753wintery

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.453394461.4
2DLD Change Limit1340272555.92322628.2
3Display Results2552550.0932741.9
 (SQL Overall)1786912556.46927622.7
 
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.