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

477 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
divvy1535648(None) 
civvy16435461civvy
chivvy20374432chivvy
davy116015522d_avy
diary95016972diary
dicey114819332dicey
dicky154816242dicky
dicty115116292dicty
didy99121502di_dy
dikey135116422dikey
dilly94923782dilly
dimly114913482dimly
dingy105721262dingy
dinky135819372dinky
dippy135111542dippy
dirty95617802dirty
dishy125712352dishy
ditsy95612562ditsy
ditty95019292ditty
ditzy186513282ditzy
diva85920882di_va
divan96114842divan
divas95418582divas
dive85634772di_ve
dived106321372dived
diver94827802diver
dives95832402dives
divot95723072divot
dizzy177410852dizzy
ivy96317442_i_vy
jivey185111872jivey
jivy176213112ji_vy
navvy14696682navvy
savvy14497502savvy
skivvy1932782skivvy
spivvy1733212spivvy
tivy1014516862ti_vy
airy75734153ai_ry
aiver85725163aiver
bevy127115223_bevy
bialy105119323bialy
biddy124612693biddy
biffy164711123biffy
biggy124413133biggy
bigly114814753bigly
bilby124912343bilby
bilgy114713713bilgy
billy105525363billy
bitsy104511303bitsy
bitty106119173bitty
cavy125920003_cavy
chevy16479993chevy
chivy164810363chivy
cissy104811073cissy
city95122623ci_ty
civet105828733civet
civic123412543civic
civie103716353civie
civil103411933civil
covey136121783covey
curvy136013373curvy
daddy116212563daddy
daffy155510283daffy
daily95922333daily
dainty105311473dainty
dairy97016303dairy
daisy95915313daisy
dally95324743dally
dandy104416703dandy
darky136018833darky
dashy125612383dashy
dauby115211223dauby
daven94916473daven
davit93424593davit
day76254113d__ay
deary95826843deary
deave95022333deave
decay114718483decay
decoy115716313decoy
decry115514353decry
deedy104315893deedy
defy114921263d_efy
deify124112763deify
deity94316773deity
delay94820633delay
delly96023873delly
delve96018263delve
demy105422853d_emy
deny86027123d_eny
deoxy1648883deoxy
deray95024183deray
derby114715343derby
derry94721373derry
dev76033773d_ev_
deva85720983d_eva
devas96218883devas
devel94217123devel
devil94714733devil
devon95113683devon
devs86424033d_evs
dewy115419023d_ewy
dexy156118553d_exy
dey77243373d__ey
dial55935063di_al
dials64925343dials
diazo15310033diazo
dib65746933di__b
dibs76233673di_bs
dice75841893di_ce
diced95824683diced
dicer85426423dicer
dices86434243dices
dick116432383di_ck
dickey165913523dickey
dicks125824693dicks
dicot85429093dicot
dicta84915633dicta
did56850513di__d
diddly12389573diddly
didie74120563didie
dido66528193di_do
didos76820813didos
didst74619613didst
die46759653di__e
died66137853di_ed
diel59034603di_el
diene65720133diene
dies55653523di_es
diet57357533di_et
diets66026643diets
dif76846893di__f
diff116228833di_ff
diffs126315483diffs
difs86027323di_fs
dig57544473di__g
digamy1335883digamy
dight104027003dight
digit73825273digit
digs66036053di_gs
dike95935763di_ke
diked115024683diked
diker105524553diker
dikes105831333dikes
dildo71911773dildo
dill55239973di_ll
dills65530973dills
dim68146493di__m
dime76237643di_me
dimer85625603dimer
dimes85833043dimes
dimity12310463dimity
dimply14339743dimply
dims75435023di_ms
din46459463di__n
dinar66319893dinar
dine55555333di_ne
dined76431993dined
diner65632903diner
dines66449153dines
ding66940953di_ng
dinge75627303dinge
dingey114914043dingey
dinghy14476963dinghy
dingo74720793dingo
dings76331403dings
dink97137803di_nk
dinkey144812763dinkey
dinkly144311083dinkly
dinks105927953dinks
dino56036753di_no
dinos65428063dinos
dins56652043di_ns
dint56759053di_nt
dints67431313dints
diode74716113diode
dioecy1235543dioecy
diol57329133di_ol
diols65521013diols
dip67848983di__p
dipody1336363dipody
dips75536913di_ps
dipso85111553dipso
dipt77339323di_pt
diram84419473diram
dire56644143di_re
direly10311553direly
direr64927073direr
dirge75117073dirge
dirk96326833di_rk
dirks105619523dirks
dirl57430023di_rl
dirls64720503dirls
dirt55550383di_rt
dirts66824463dirts
dis46459893di__s
disc76123233di_sc
disci85815023disci
disco85616073disco
discs85316263discs
dish86328333di_sh
disk96625833di_sk
disks105417473disks
dismay12229473dismay
disme85716243disme
diss56434483di_ss
dit47071333di__t
dita56032523di_ta
ditas65923673ditas
ditch115015093ditch
dite55547553di_te
dites66339153dites
dits56450523di_ts
ditto65315603ditto
ditz146929513di_tz
divans104612393divans
divers105024963divers
divert103922813divert
divest106820073divest
divide113410893divide
divine103514463divine
diving113717953diving
divots104712203divots
divvied1544813divvied
divvies1457663divvies
divvying1932773divvying
diwan95712553diwan
dixit134420593dixit
dizen155214933dizen
djinny1732873djinny
dobby136013623dobby
doby106022163d_oby
dodgy116611463dodgy
dogey105719513dogey
doggy115214873doggy
dogy96126493d_ogy
doily95321033doily
dolly96125203dolly
donsy96414683donsy
doody105517913doody
dooly94821803dooly
doomy116018263doomy
doozy186813713doozy
dopey116020353dopey
dopy106224153d_opy
dorky135518743dorky
dormy115817463dormy
dorty96220813dorty
dory85836233d_ory
dotty94516103dotty
doty86128223d_oty
dove85131563d_ove
doven94718553doven
doves94728153doves
dowdy136112543dowdy
downy125714553downy
dowry126312483dowry
doxy156419953d_oxy
doyly124514013doyly
dozy175920323d_ozy
drave95219273drave
dray85428093d_ray
drifty13418223drifty
drily95816523drily
drippy14445653drippy
drive95318003drive
drivel105110383drivel
driven105210143driven
driver104714493driver
drives105117113drives
drove95518063drove
dry76526033d__ry
dryly12538453dryly
duchy144310873duchy
ducky154216113ducky
duddy114911033duddy
dully94921633dully
duly85323033d_uly
dumky154511343dumky
dummy134712783dummy
dumpy135414753dumpy
dungy104713643dungy
dusky135213043dusky
dusty96018323dusty
duty85321453d_uty
duvet9321873duvet
dykey16608673dykey
edify12308563edi_fy
envoy1156713envoy
envy10411253_envy
fiery114714793fiery
fifty145211423fifty
filly114424903filly
filmy136114043filmy
finny114716753finny
firry115713533firry
fishy146011663fishy
fitly115114973fitly
five107629743fi_ve
fiver116024943fiver
fives116027363fives
fizzy199015083fizzy
giddy115810203giddy
gilly94321633gilly
gimpy135212233gimpy
ginny95314573ginny
gipsy11579543gipsy
girly94415293girly
give85829353gi_ve
given95915283given
giver94921203giver
gives95324873gives
gravy125512113gravy
heavy144814183heavy
hilly114422163hilly
hinky155618753hinky
hinny115616673hinny
hiply134113613hiply
hippy155112793hippy
hissy116112123hissy
hive106029673hi_ve
hived125217913hived
hives116925513hives
icky136315753_icky
icy86322123_i_cy
idiocy1273463idiocy
idly85617323_idly
iffy135312283_iffy
illy76925333_illy
immy114611823_immy
inby95315653_inby
inky115321583_inky
inly75622213_inly
ivory1137373_ivory
jiffy21458313jiffy
jiggy17549143jiggy
jimmy19538503jimmy
jimpy195210823jimpy
jive146123593ji_ve
jived165115043jived
jiver155119053jiver
jives154820813jives
kicky135012333kicky
kiddy144910273kiddy
kilty125213893kilty
kinky115816383kinky
kissy125510313kissy
kitty124614563kitty
kiva116516403ki_va
kivas124614733kivas
leavy115715773leavy
levy106418503_levy
lieve86315473lieve
lily76730183li_ly
limby125714063limby
limey104721043limey
limy95727713li_my
lindy96918313lindy
liney87029623liney
lingy96925133lingy
linky127622383linky
linty87126563linty
liny78141323li_ny
lippy124511903lippy
live76540993li_ve
lived95523723lived
lively123310813lively
liven85021733liven
liver85132963liver
livery124910893livery
lives86133193lives
livid96714423livid
livre85613253livre
marvy135014033marvy
middy124812593middy
miffy163910193miffy
milky144014443milky
milty104720073milty
mincy125817413mincy
mingy115520183mingy
minny104518663minny
minty106323903minty
mirky146315523mirky
miry96326743mi_ry
missy105617563missy
misty106120453misty
mity95528203mi_ty
navy107518633_navy
nervy114610863nervy
nieve85613183nieve
nifty115211633nifty
ninny84514933ninny
nippy124911113nippy
nitty85418313nitty
nival84915773nival
nixy145714513ni_xy
oily77932253oi_ly
peavy135014843peavy
picky165416943picky
piety105817303piety
piggy124011433piggy
pigmy13299433pigmy
pily96132733pi_ly
piney105727503piney
pinky145823403pinky
pinny105222063pinny
piny911838353pi_ny
pipy115421513pi_py
pithy135614463pithy
pity96031933pi_ty
pivot106523873pivot
pixy166117763pi_xy
privy13439833privy
ribby12419673ribby
ridgy104110643ridgy
riley84420583riley
rimy96621283ri_my
rindy95717393rindy
risky126311523risky
ritzy175611163ritzy
rival85216503rival
rive75537723ri_ve
rived94825613rived
riven85121623riven
river85731693river
rives85336003rives
rivet85636363rivet
savoy114713883savoy
sieve84918843sieve
silky125315823silky
silly84527613silly
silty84721633silty
silva82714023silva
sissy85812073sissy
siver85728613siver
sixty154912733sixty
sizy164816393si_zy
tidy86822413ti_dy
tinny85317653tinny
tiny76134633ti_ny
tippy125411793tippy
tipsy106010503tipsy
titty85316653titty
tizzy16548893tizzy
vichy1639043vichy
viewy14518103viewy
viny106025953vi_ny
viva106119093vi_va
vivary1536983vivary
vivas114815023vivas
vive105426623vi_ve
vivid125112313vivid
vivify1834703vivify
wavey145115543wavey
wavy136620473_wavy
widdy136112183widdy
wifey144913673wifey
wifty144212093wifty
wiggy134510733wiggy
willy115321913willy
wily106428813wi_ly
wimpy155911923wimpy
windy126118103windy
winey115325433winey
wingy126521033wingy
winy107034323wi_ny
wiry106422833wi_ry
wispy137210973wispy
withy144813763withy
witty114717013witty
wive105931753wi_ve
wived125121503wived
wiver115924513wiver
wives115328923wives
zincy195413513zincy
zingy186516133zingy
zinky215314813zinky
zippy21518743zippy

Search took 5 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 Filter178691836670.1231452772.4
2DLD Change Limit836674774.53018469.5
3Display Results4774770.1263785.7
 (SQL Overall)1786914774.77937390.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.