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

257 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
dossils866977(None) 
dossals8379301dossals
dossels85511611dossels
dossil75110901dossil_
fossils10379011fossils
bossies94116832bossies
bossily1237562bossily
dassies84418662dassies
distils83015802distils
dorsals84110852dorsals
dorsels84412582dorsels
dossal75510302dossal_
dossel74813642dossel_
dossers84516232dossers
dosses76126272doss_es
dossier83711692dossier
dossiers9318042dossiers
dossing93313272dossing
fossil9379352fossil_
gossips1035902gossips
tonsils7310182tonsils
abseils935973abseils
apostils1046773apostils
assails769093assails
assoils776663assoils
basils85717473_basils
boils75427193bo__ils
bosses85925403boss_es
bossier93712423bossier
bossiest103112213bossiest
bossing103714603bossing
bossism1136063bossism
bossisms1244703bossisms
brasils9410973brasils
cassias93514343cassias
cassis84818853cassi_s
cissies94116153cissies
coils75030083co__ils
consols92914073consols
consuls92412323consuls
cosies84932153co_sies
cosily113613853co_sily
cosmids1237633cosmids
cossets95014283cossets
cousins9516003cousins
daisies84217093daisies
damsels10126713damsels
dashis104414393dashi_s
dassie74615573dassi_e
deasil71110983deasil_
deils65722863d__eils
dentils84115583dentils
derails84216393derails
desists83611723desists
desmids1166603desmids
despoils1145623despoils
details84214043details
devils104412813d_evils
diesels8429143diesels
diesis74013493diesi_s
dismals102010243dismals
dismiss1038153dismiss
dispels10310503dispels
disses75225963diss_es
dissing94517683dissing
distil73616433distil_
distill83011323distill
distills9319043distills
dobbies124113063dobbies
dobbins12379533dobbins
dobies94422093do_bies
dobsons1036203dobsons
docile94213123do_cile
doeskins1344903doeskins
doggies103613023doggies
dogies85022253do_gies
doilies84017363doilies
doily95321033do__ily
doits66223673do__its
dollies83620983dollies
dolls66126923do__lls
dols56943053do___ls
domains10510873domains
domicils1345073domicils
donsie7613643donsi_e
donzels1735393donzels
doobies103915673doobies
doodies94218773doodies
doolies83920713doolies
doomily1336133doomily
doorsill943763doorsill
doorsills1043003doorsills
doozies173812723doozies
dopily123510463do_pily
dories75232363do_ries
dormins10311273dormins
dorsal74613943dorsal_
dorsel75315503dorsel_
dorsers83516303dorsers
dosages92310803dosages
dosers75723633do_sers
doses65938503do_s_es
dosing83920273do_sing
doss56235043do_s__s
dossed84516633doss_ed
dosser74417973doss_er
dottels8327783dottels
dottily1147283dottily
dousers84817273dousers
douses74928933dous_es
dousing93315763dousing
dowdies123412733dowdies
dowdily1534953dowdily
dowels104813343do_wels
dowries114413983dowries
dowsers115013533dowsers
dowses105718303dows_es
dowsing123411123dowsing
doxies143917853do_xies
doylies114512573doylies
dozily19329103do_zily
drails74716953d_rails
dressily1246443dressily
dropsies1138693dropsies
droskies13186343droskies
drosses84513823dross_es
drossier956313drossier
drossiest1036523drossiest
drowsily1583723drowsily
duskily15236743duskily
dustily113211523dustily
eosins64419163eo_sins
fissile10269653fissile
flossies112810123flossies
flossily1434523flossily
foils85025813fo__ils
fossas94610703foss_as
fosses96022083foss_es
fossick16134733fossick
fossicks17134163fossicks
fossilise1243723fossilise
fusils93912343_fusils
fussily13267603fussily
gassily1137813gassily
glossies93311253glossies
glossily1235093glossily
gospels1035593gospels
gossans836783gossans
gossip946433gossi_p
gossipy1343953gossipy
gussies82813303gussies
hassels104311023hassels
hissies103915823hissies
horsily1338843horsily
hosels94218613ho_sels
hostels103712323hostels
hostile10312553hostile
hostiles11312213hostiles
housels105312143housels
hussies103213293hussies
instils7811453instils
jassids1586143jassids
josses135117683joss_es
lassies74420103lassies
lassis65216703lassi_s
losels64714593lo_sels
losses65925233loss_es
lousily1038333lousily
massifs1237743massifs
messily12298813messily
missals93914433missals
missels94614813missels
missies93423983missies
missile92815403missile
missiles103015083missiles
missis84417503missi_s
moils76125753mo__ils
morsels94112663morsels
mosaics1138073mosaics
mossers94116193mossers
mosses85527683moss_es
mossier94413813mossier
mossiest103112443mossiest
mossing103915423mossing
mousily1239393mousily
mussels9419843mussels
mussily12279773mussily
noesis6311443noesi_s
noils55024333no__ils
noisily1038403noisily
nosily93712683no_sily
nostrils848183nostrils
oasis56422553_oasi_s
oils46337973_o__ils
opsins8411713_opsins
osmics1036463_osmics
osmols8137313_osmols
osseins736133_osseins
ossia53710403_ossi_a
ossicle944483_ossicle
ossicles1054183_ossicles
ossify1244973_ossify
ousels64815283_ousels
passels93913023passels
pastils94416173pastils
pensils92811593pensils
pistils93314303pistils
podsols1056513podsols
poesies93217403poesies
pontils9312213pontils
popsies112816463popsies
posies84431433po_sies
posits85718713po_sits
posses85128803poss_es
possess9419123possess
possets94212773possets
possible1245813possible
possibly1544483possibly
possums1145753possums
postals93716383postals
posties93128813posties
postins93721203postins
potsies93019483potsies
poussies1038113poussies
prossies101515223prossies
pussies93615693pussies
resails74616743resails
roils54826793ro__ils
roshis9311793roshi_s
rosily93914713ro_sily
rosins64521863ro_sins
sails55738103__sails
sassies74719263sassies
sassily1038723sassily
sessile739523sessile
sissies73716603sissies
soils55327983__soils
tahsils1035053tahsils
tassels74510853tassels
tassies74918933tassies
tocsins939963tocsins
toils54527493to__ils
tonsil6311873tonsil_
topsails1075093topsails
topsoils1095143topsoils
tossers74713503tossers
tosses65225393toss_es
tossing83612563tossing
tossups964023tossups
tussis6379953tussi_s
vassals1057953vassals
vessels1035933vessels
wassails1145953wassails
wormils1236733wormils
wussies103411083wussies
zorils153810883zo_rils
zoysias1943843zoysias

Search took 8 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.436409841.7
2DLD Change Limit1340272576.76619808.9
3Display Results2572570.0932763.4
 (SQL Overall)1786912577.29524495.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.