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

294 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
dossil7511090(None) 
dossal75510301dossal
dossel74813641dossel
dossils8669771dossils
fossil9379351fossil
bossily1237562bossily
dassie74615572dassie
deasil71110982deasil
distil73616432distil
donsie7613642donsie
dorsal74613942dorsal
dorsel75315502dorsel
doss56235042doss__
dossals8379292dossals
dossed84516632dossed
dossels85511602dossels
dosser74417972dosser
dosses76126272dosses
dossier83711692dossier
dossing93313262dossing
fossils10379012fossils
gossip946432gossip
ossia53710402_ossia
tonsil6311872tonsil
abseil837183abseil
apostil947903apostil
assail6610153assail
assoil688543assoil
basil75122273_basil
bassi77019323bassi_
boil66335183bo__il
boss65938343boss__
bossed94816533bossed
bosses85925403bosses
bossier93712423bossier
bossies94116833bossies
bossing103714603bossing
bossism1136063bossism
bossy105515973boss_y
brasil8713863brasil
byssal1134993byssal
byssi10507993byssi_
cassia83714763cassia
cassis84818853cassis
coil66439653co__il
consol82614113consol
consul82312303consul
cosie74728263co_sie
cosily113613853co_sily
cosmic12410343cosmic
cosmid11810643cosmid
coss66143493coss__
cosset84125863cosset
costal85419513costal
cousin8517153cousin
damsel9148033damsel
dashi95013113dashi_
dashis104414393dashis
dassies84418663dassies
deil56231623d__eil
dentil74017883dentil
derail74218813derail
desist74818813desist
desmid1048363desmid
despoil1046523despoil
detail74516433detail
devil94714733d_evil
diesel74410403diesel
diesis74013493diesis
disci85815023disci_
dismal92412243dismal
dispel9310323dispel
diss56434483diss__
dissed85220173dissed
disses75225963disses
dissing94517683dissing
distal73615763distal
distill83011323distill
distils83015803distils
dobbin11339513dobbin
dobie84920323do_bie
dobson936593dobson
docile94213123do_cile
docs75631153docs__
does56554473does__
doeskin1245153doeskin
doest65829523does_t
doggie93910893doggie
dogie75222793do_gie
dogs66440153dogs__
doily95321033do__ily
doit56347853do__it
dol47150653do___l
dolci84912603dolci_
doll56632493do__ll
dols56943053dols__
domain9511323domain
domal85619203do_mal
domic104317243do_mic
domicil1246433domicil
doms76239573doms__
dons56048703dons__
donsy96414683dons_y
donzel1636313donzel
doobie94712683doobie
doolie73916833doolie
doomily1336133doomily
doorsill943763doorsill
doozie163910643doozie
dopily123510463do_pily
dormie9312623dormie
dormin9312313dormin
dors56747603dors__
dorsa64617283dors_a
dorsad8408973dorsad
dorsals84110843dorsals
dorsels84412573dorsels
dorser74819173dorser
dorsum947623dorsum
dos48062313do_s__
dosage82810003dosage
dose56442433do_s_e
dosed76626913do_sed
doser66228563do_ser
dosers75723633dosers
doses65938503do_ses
dosing83920263dosing
dossers84516233dossers
dossiers9318043dossiers
dost57248353do_s_t
dotal64919623do_tal
dots55647663dots__
dottel73610893dottel
dottily1147283dottily
douse66329723dous_e
doused84821163doused
douser75621633douser
douses74928933douses
dousing93315753dousing
dovish1338103dovish
dowdily1534953dowdily
dowel95618193do_wel
dowie94721143do_wie
dows85941053dows__
dowse96020813dows_e
dowsed115015013dowsed
dowser104716083dowser
dowses105718303dowses
dowsing123411113dowsing
doxie136017153do_xie
dozily19329103do_zily
drail65020973d_rail
dressily1246443dressily
dross65418093dross__
drosses84513823drosses
drossier956313drossier
drossy10528473dross_y
drowsily1583723drowsily
duskily15236743duskily
dustily113211523dustily
eosin55220923eo_sin
fissile10269653fissile
flossie10337443flossie
flossily1434523flossily
foil76433913fo__il
foss76431643foss__
fossa85812633foss_a
fossae95510373fossae
fossas94610703fossas
fosse86119463foss_e
fosses96022083fosses
fossick16134733fossick
fusil84715323_fusil
fussily13267603fussily
gassily1137813gassily
glossal8447053glossal
glossily1235093glossily
gospel936533gospel
gossan747233gossan
gossips1035903gossips
gossipy1343953gossipy
gussie72910153gussie
hassel95614213hassel
horsily1338843horsily
hosel86024813ho_sel
hostel93914153hostel
hostile10312553hostile
housel95217043housel
instil61111383instil
jassid1467223jassid
joss115925593joss__
josses135117683josses
koss85224813koss__
lassi56316853lassi_
lassie64917743lassie
lassis65216703lassis
loessal744393loessal
loessial843783loessial
losel54419423lo_sel
loss45337963loss__
losses65925233losses
lossy85214643loss_y
lousily1038333lousily
massif11412533massif
messily12298813messily
missal84314903missal
missel85216523missel
missile92815403missile
missis84417503missis
moil65534083mo__il
morsel85815893morsel
mosaic10311143mosaic
moss67641033moss__
mossed94818893mossed
mosser84618273mosser
mosses85527683mosses
mossier94413813mossier
mossing103915423mossing
mosso74715183moss_o
mossy105217063moss_y
mousily1239393mousily
mussel83412903mussel
mussily12279773mussily
noesis6311443noesis
noil46133243no__il
noisily1038403noisily
nosily93712683no_sily
nostril749273nostril
oasis56422553_oasis
oil37452053_o__il
opsin7613473_opsin
osmic939913_osmic
osmol7138573_osmol
ossa43714163_oss_a
ossein636593_ossein
ossicle944483_ossicle
ossify1244973_ossify
ostia52315583_ostia
ousel55222403_ousel
passel85117003passel
passim10410283passim
pastil85018323pastil
pensil83013333pensil
pistil83915073pistil
podsol946853podsol
pontil8315463pontil
popsie103013053popsie
posit75833333po_sit
posse74722273poss_e
posses85128803posses
posset84923253posset
possible1245813possible
possibly1544483possibly
possum1057953possum
postal84317533postal
postie84123963postie
postin83521033postin
potsie83916023potsie
poussie936623poussie
prossie91812953prossie
resail64418733resail
roil46235293ro__il
roshi8310753roshi_
roshis9311793roshis
rosily93914713ro_sily
rosin55325313ro_sin
sail45447163__sail
sassily1038723sassily
sessile739523sessile
soil46138823__soil
sonsie6614853sonsie
tahsil936343tahsil
tassel66014773tassel
tassie66017023tassie
tocsin8311003tocsin
toil46536283to__il
tonsils7310183tonsils
topsail976523topsail
topsoil977143topsoil
torsi57423363torsi_
toss45637973toss__
tossed74215223tossed
tosser64215663tosser
tosses65225393tosses
tossing83612563tossing
tossup875293tossup
tussal6288323tussal
tussis6379953tussis
vassal979243vassal
vessel937953vessel
wassail1056133wassail
wormil1138043wormil
zoril143916693zo_ril
zoysia1844163zoysia

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 Filter1786911127160.1561145455.1
2DLD Change Limit1127162946.26617988.5
3Display Results2942940.0933161.3
 (SQL Overall)1786912946.51527427.6
 
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.