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

306 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
divvies145766(None) 
civvies1555841civvies
divvied1544811divvied
chivvies1954422chivvies
civies114116442ci_vies
davies105020512d_avies
diaries83321952diaries
dickies143416342dickies
didies84621832di_dies
dillies84122162dillies
dingies93618242dingies
dinkies123716032dinkies
dirties83119382dirties
ditties83116982ditties
dives95832402di_v_es
divides123211452divides
divines113514722divines
dizzies16279752dizzies
ivies84215762_i_vies
navvies1335322navvies
savvies1337602savvies
skivvies18112882skivvies
bevies114017303_bevies
bialies93618413bialies
biddies113514493biddies
biffies152710853biffies
biggies113813523biggies
bikies124515163bi_kies
bilbies114712343bilbies
billies93923503billies
birdies104016213birdies
birkies133712433birkies
cavies114525003_cavies
chevies153511443chevies
chivies153412853chivies
chivvied2052523chivvied
cissies94116153cissies
cities84524853ci_ties
civics13397823ci_vics
civie103716353ci_vie_
daddies103414943daddies
dailies84219263dailies
dainties9312403dainties
dairies84217733dairies
daisies84217093daisies
dallies84023193dallies
dandies94121443dandies
darbies104216983darbies
darkies124015753darkies
dassies84418663dassies
datives11310073datives
dauties83315763dauties
davits104012363d_avits
dawties113312703dawties
dearies83526273dearies
deaves105319533deav_es
decries103319803decries
defies104624053d_efies
deifies113317453deifies
deities82621923deities
dellies83622213dellies
delves104917083delv_es
demies94825803d_emies
denies74729643d_enies
derbies103016053derbies
derives114017813derives
derries83124623derries
deveins1138803deveins
devices133212583devices
devils104412813d_evils
devise104215753d_evise
devises114116763devises
devoices14307413devoices
devoirs1175783devoirs
devotes113713753devotes
dexies145018343d_exies
diacids1137863diacids
diamides1238823diamides
diamines11311643diamines
diamins10312213diamins
diapirs10347643diapirs
diazines1838713diazines
diazins1739183diazins
dibbles124013333dibbles
dices86434243di__ces
dicier94416233di_cier
diciest103316523di_ciest
dickie133913113dickie_
dickier143512453dickier
dickiest153412503dickiest
dictier103411863dictier
dictiest113212783dictiest
diddles103915073diddles
diddlies1137593diddlies
didie74120563di_die_
didoes85716963di_does
dienes75719903di_enes
dies55653523d___ies
dieses75218693di_eses
diesis74013493diesi_s
digamies1238643digamies
digits84114533di_gits
dikdiks1242563dikdiks
dikes105831333di__kes
dilates83220663dilates
dildoes9229243dildoes
dilutes82911973dilutes
dimes85833043di__mes
dimities11314003dimities
dimples122813213dimples
dimwits1344513dimwits
dindles93817243dindles
dines66449153di__nes
dinges83825423di_nges
dinghies1347363dinghies
dingier93513673dingier
dingiest102915373dingiest
dingles93818323dingles
dingoes94114833dingoes
dinkier123411503dinkier
dinkiest133812873dinkiest
diodes83915783di_odes
dioecies1138933dioecies
diorites9313523diorites
dioxides1756203dioxides
dioxids1655683dioxids
dioxins1568003dioxins
diploes101111493diploes
dipodies1238413dipodies
dipoles101013753dipoles
dippier123111393dippier
dippiest132511133dippiest
dirges84915103di_rges
dirtied93210853dirtied
dirtier83312093dirtier
dirtiest93014203dirtiest
dishes104622653di_shes
dishier113613403dishier
dishiest12313683dishiest
dislikes132810843dislikes
dismes95617673di_smes
dismiss1038153dismiss
disses75225963di_sses
distils83015803distils
disuses84015413disuses
ditches133215713ditches
dites66339153di__tes
ditsier83010293ditsier
ditsiest92111323ditsiest
ditzes163212423di_tzes
ditzier17307963ditzier
ditziest18218473ditziest
divans104612393di_vans
divas95418583di_v_as
dive85634773di_v_e_
dived106321373di_v_ed
diver94827803di_v_er
diverges13258313diverges
divers105024963di_vers
diverse11429993diverse
diverts114412033diverts
divest106820073di_v_est
divests114510933divests
divide113410893di_vide
divided13378593divided
divider12278953divider
dividers13257213dividers
divine103514463di_vine
divined12329693divined
diviner11369883diviner
diviners12308353diviners
divinest123012173divinest
diving113717953di_ving
divinise1267143divinise
divinises1367013divinises
divinizes2266673divinizes
divorces1445673divorces
divots104712203di_vots
divulges1343603divulges
divulse1134913divulse
divulses1244763divulses
divvy15356483divv__y
divvying1932773divvying
dixits144210313di_xits
dizzied17236133dizzied
dizzier16317543dizzier
dizziest17266723dizziest
dobbies124113063dobbies
dobies94422093d_obies
doggies103613023doggies
dogies85022253d_ogies
doilies84017363doilies
dollies83620983dollies
doobies103915673doobies
doodies94218773doodies
doolies83920713doolies
doozies173812723doozies
dories75232363d_ories
dovekies16115003dovekies
doves94728153d_ov_es
dowdies123412733dowdies
dowries114413983dowries
doxies143917853d_oxies
doylies114512573doylies
dries64733673d__ries
drives105117113driv_es
droves105116673drov_es
duchies133312313duchies
duckies143613813duckies
dummies123012133dummies
durries83817353durries
duties74921903d_uties
edifies113012283edi_fies
envies9314053_envies
fifties132111083fifties
fillies103420253fillies
fives116027363fi_v_es
giddies103713363giddies
gillies84120963gillies
gimmies123010113gimmies
gipsies1039903gipsies
girlies83013703girlies
gives95324873gi_v_es
gravies11314093gravies
heavies132713873heavies
hickies163614743hickies
hinnies103615103hinnies
hippies142813743hippies
hissies103915823hissies
hives116925513hi_v_es
idiocies1145223idiocies
immies102412443_immies
indies73822783_indies
invites103915813_invites
ivied94710523_i_vied
ivories10310713_ivories
jiffies20327473jiffies
jimmies18328783jimmies
jives154820813ji_v_es
jivier16438613ji_vier
jiviest1738113ji_viest
kiddies133412283kiddies
kidvids1643113kidvids
killies113318113killies
kilties113014143kilties
kitties113213623kitties
levies93919863_levies
lilies63021413li_lies
lindies8416583lindies
liveries11314373liveries
lives86133193li_v_es
livier97514593li_vier
liviers104211073li_viers
livres94311863li_vres
mavies114923193_mavies
middies113116153middies
minnies93617363minnies
mislies92922283mislies
missies93423983missies
movies115118453_movies
navies95218623_navies
nieves94311293niev_es
nifties102612503nifties
ninnies73713613ninnies
nixies135313873ni_xies
outvies102214243outvies
peavies122213403peavies
pieties9419223pieties
piggies113813483piggies
pigmies122610993pigmies
pinkies133818263pinkies
pinnies93318443pinnies
pities83828083pi_ties
pixies154915513pi_xies
privies122414263privies
revives134715543revives
rivages1138873rivages
rives85336003ri_v_es
savvied1433803savvied
savvier1335483savvier
savviest1435983savviest
shavies134213203shavies
sickies133717503sickies
sieves93216003siev_es
silkies113715693silkies
sillies73425083sillies
silvics1235563silvics
sissies73716603sissies
sixties14310973sixties
skivvied1971813skivvied
spavies123012943spavies
tidies74721833ti_dies
titties73617363titties
tizzies15287893tizzies
vichies15310623vichies
vies75238623___vies
vivaces1536413vivaces
vivaries1439263vivaries
vivifies1747023vivifies
wavies125019843_wavies
widdies123514033widdies
wienies102213683wienies
willies103920153willies
withies133913543withies
wives115328923wi_v_es
yippies14279293yippies

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.1431249587.4
2DLD Change Limit1340273066.62320236.6
3Display Results3063060.1102781.8
 (SQL Overall)1786913066.87625987.6
 
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.