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

289 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
fossil937935(None) 
dossil75110901dossil
fossils10379011fossils
bossily1237562bossily
dossal75510302dossal
dossel74813642dossel
dossils8669772dossils
fissile10269652fissile
flossie10337442flossie
flossily1434522flossily
foil76433912fo__il
foss76431642foss__
fossa85812632foss_a
fossae95510372fossae
fossas94610702fossas
fosse86119462foss_e
fosses96022082fosses
fossick16134732fossick
fusil84715322f_usil
fussily13267602fussily
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
cousin8517163cousin
dassie74615573dassie
deasil71110983deasil
distil73616433distil
donsie7613643donsie
dorsal74613943dorsal
dorsel75315503dorsel
doss56235043doss__
dossals8379293dossals
dossed84516633dossed
dossels85511603dossels
dosser74417973dosser
dosses76126273dosses
dossier83711693dossier
dossing93313273dossing
eosin55220923eo_sin
fail74840243f__ail
falsie93513853falsie
fascia1148703fascia
fascial1258303fascial
felsic1147053felsic
fess76529163fess__
fesse86116333fess_e
fessed104515063fessed
fesses94820253fesses
fessing113812863fessing
festal94213563festal
fibril1137163fibril
fil65447143f___il
fiscal1139333fiscal
fishily1637643fishily
fission1038733fission
fistic11812573fistic
flail85316183f_lail
floosie10378933floosie
floss85118263floss__
flossed11388533flossed
flosser10339693flosser
flosses103411973flosses
flossier11326973flossier
flossies112810123flossies
flossing12247903flossing
flossy12517703floss_y
foal76630923fo__al
foamily1546543foamily
fobs96034273fobs__
focal104917673fo_cal
foci94521013fo_ci_
fodgel1136403fodgel
foes76543443foes__
foetal9311883foetal
foetid10510513foetid
foggily1535053foggily
fogie96719003fo_gie
fogs87035003fogs__
foils85025813fo__ils
foin77231563fo__in
foison948933foison
foist85730973fois_t
foists95413983foists
folia83618933fo_lia
folic105319323fo_lic
folio83820883fo_lio
folkie13369613folkie
folksily1843443folksily
follis93113903follis
fons76943893fons__
fontal9313143fontal
foodie104413843foodie
fool75330593fo__ol
footie94718143footie
footsie1047653footsie
fops96532683fops__
forbid123312433forbid
fordid113512053fordid
foresail1147823foresail
formal113215203formal
formic13310453formic
formol112910333formol
formyl14276443formyl
fornix1636033fornix
forrit91916623forrit
fortis95418613fortis
fossate10388603fossate
fossicks17134163fossicks
fossilise1243723fossilise
fossilize2143853fossilize
fossorial1243793fossorial
foster94322223foster
foul77027583fo__ul
foveal1237703foveal
fowl105723633fo__wl
foxily1947253fo_xily
foxskin2143133foxskin
foxtail1745383foxtail
foys105628293foys__
frail85220213f_rail
frazil1847223frazil
frostily1436693frostily
fulfil1246423fulfil
fusain958643fusain
fusel85218493f_usel
fusile94313493f_usile
fusils93912343f_usils
fuss76027933fuss__
fussed104613803fussed
fusser94813773fusser
fusses94920553fusses
fussier103610673fussier
fussing113611683fussing
fussy115613953fuss_y
fustic11910633fustic
fustily133111373fustily
fuzil173810703f_uzil
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
moil65534093mo__il
morsel85815893morsel
mosaic10311143mosaic
moss67641033moss__
mossed94818893mossed
mosser84618273mosser
mosses85527683mosses
mossier94413813mossier
mossing103915423mossing
mosso74715183moss_o
mossy105217063moss_y
mousily1239393mousily
mussel83412903mussel
mussily12279773mussily
noesis6311443noesis
noil46133243no__il
noisily1038403noisily
nonfossil1252973nonfossil
nosily93712683no_sily
nostril749303nostril
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
potsie83916033potsie
poussie936623poussie
prossie91812953prossie
resail64418733resail
roil46235293ro__il
roshi8310753roshi_
roshis9311793roshis
rosily93914713ro_sily
rosin55325313ro_sin
sail45447163__sail
sassily1038723sassily
sessile739523sessile
soil46138833__soil
sonsie6614863sonsie
subfossil1451933subfossil
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 6 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.1401276364.3
2DLD Change Limit1127162895.37620966.5
3Display Results2892890.0933107.5
 (SQL Overall)1786912895.60931857.9
 
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.