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 “dicer” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

223 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
dicer8542642(None) 
deicer94114411deicer
dice75841891dice_
diced95824681diced
dicers94720741dicers
dices86434241dices
dicey114819331dicey
dicier94416231dicier
dicker134521401dicker
diker105524551diker
dimer85625601dimer
diner65632901diner
direr64927071direr
diver94827801diver
nicer74618291nicer
ricer74726611ricer
aider65431132aider
aimer75926822aimer
airer54927892airer
aiver85725162aiver
bice86235562bice_
bicep115413542bicep
bices95029962bices
bicker144819172bicker
bider85728372bider
bier65531832bi_er
biker116022562biker
biner75930692biner
biter75030032biter
chicer134513602chicer
cicero1048502cicero
cider84723312cider
citer74827332citer
dace76934922dace_
daces85030682daces
dacker134920752dacker
daiker115113032daiker
dancer94817612dancer
darer65230792darer
dater65332312dater
decern91310952decern
decker135215992decker
decor84717572decor
deer56739022d_eer
defer94619752defer
deice84320032deice_
deiced104214482deiced
deicers103612732deicers
deices94119372deices
deter65028042deter
dialer74315432dialer
diaper94513112diaper
dibber114614712dibber
dick116432382dic_k
dicked144920862dicked
dickers144117662dickers
dickey165913522dickey
dickier143512452dickier
dicks125824692dicks
dicky154816242dicky
dicot85429092dicot
dicta84915632dicta
dictier103411862dictier
dicty115116292dicty
die46759652di_e_
died66137852di_ed
diel59034602di_el
dies55653522di_es
diet57357532di_et
dieter73516772dieter
differ133910842differ
digger94616082digger
dike95935762dike_
diked115024682diked
dikers114418792dikers
dikes105831332dikes
dikey135116422dikey
dime76237642dime_
dimers94321092dimers
dimes85833042dimes
dimmer114112612dimmer
dinar66319892dinar
dine55555332dine_
dined76431992dined
dinero75612642dinero
diners75525952diners
dines66449152dines
dinger85323672dinger
dinner74217162dinner
dipper114017792dipper
dire56644142dire_
disced104914652disced
discern1038492discern
diseur738842diseur
ditcher134012002ditcher
dite55547552dite_
dites66339152dites
dither104417682dither
dive85634772dive_
dived106321372dived
divers105024962divers
divert103922812divert
dives95832402dives
dizen155214932dizen
docker134417652docker
doer57734702d_oer
doper86128392doper
doser66228562doser
doter65428622doter
dower95027702dower
dozer158419272dozer
drier64423962drier
driver104714492driver
dryer95111462dryer
duce76933502duce_
duces86327472duces
ducker134317992ducker
duiker114110592duiker
duper85519002duper
dyer85522112d_yer
eider64624742eider
facer105525052facer
fiber104921132fiber
fice95737112fice_
fices106031162fices
fifer115519972fifer
filer85433002filer
finer85431562finer
firer811229252firer
fiver116024942fiver
fixer154717832fixer
giber85417702giber
giver94921202giver
hider95024082hider
hiker125119392hiker
hirer85423122hirer
ice56737242_ice_
iced78721892_iced
ices66129642_ices
icier74313752_icier
icker114018442_icker
idler65015662idler
jiber145115702jiber
jiver155119052jiver
juicer1536282juicer
kicker114116182kicker
kier86526812ki_er
kiter95523212kiter
lacer75833752lacer
liber74723622liber
lice66045062lice_
licker125222042licker
lier45942462li_er
lifer85822152lifer
liger65024472liger
liker95627062liker
liner55938922liner
liter54736342liter
liver85132962liver
macer912126942macer
mice87442232mice_
miler75733062miler
mimer94825762mimer
mincer104017362mincer
miner76933542miner
miser75430402miser
miter75734792miter
mixer145017642mixer
nice65534712nice_
nicker123818702nicker
niter55028972niter
oiler54628282oiler
pacer96131612pacer
pice84641092pice_
picker144422172picker
piecer105213082piecer
pier66035292pi_er
piker115622842piker
pincer104019172pincer
piper96523192piper
pricer103918292pricer
racer75233022racer
rice64942912rice_
riced85825542riced
ricers84120992ricers
rices75536152rices
richer114015042richer
rider65231302rider
rifer84721982rifer
rimer75429242rimer
riper74328402riper
riser55431052riser
river85731692river
sice65545592sice_
sices75637272sices
sicker124023902sicker
siker95326032siker
siver85728612siver
sizer145521812sizer
slicer84117602slicer
spicer104719312spicer
ticker124321502ticker
tier44936142ti_er
tiger65718632tiger
tiler56131022tiler
timer75626042timer
titer55430612titer
ulcer7310752ulcer
vicar10513862vicar
vice95732852vice_
viced115118182viced
vices105725532vices
vier75428152vi_er
viler86324162viler
viper105017302viper
voicer113910542voicer
wicker154518672wicker
wider94826352wider
wincer115018192wincer
wiper105421292wiper
wirer85124952wirer
wiser85522802wiser
wiver115924512wiver

Search took 2 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 Filter178691538000.310576422.6
2DLD Change Limit538002231.39338621.7
3Display Results2232230.0633539.7
 (SQL Overall)1786912231.766101184.0
 
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.