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

246 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
fossils1037901(None) 
dossils8669771dossils
fossil9379351fossil_
bossies94116832bossies
bossily1237562bossily
dossals8379292dossals
dossels85511602dossels
dossil75110902dossil_
fissile10269652fissile
flossies112810122flossies
flossily1434522flossily
foils85025812fo__ils
fossas94610702foss_as
fosses96022082foss_es
fossick16134732fossick
fossicks17134162fossicks
fossilise1243722fossilise
fusils93912342f_usils
fussily13267602fussily
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
consuls92412313consuls
cosies84932153co_sies
cosily113613853co_sily
cosmids1237633cosmids
cossets95014283cossets
cousins9516003cousins
dassies84418663dassies
distils83015803distils
dorsals84110843dorsals
dorsels84412573dorsels
dossal75510303dossal_
dossel74813643dossel_
dossers84516233dossers
dosses76126273doss_es
dossier83711693dossier
dossiers9318043dossiers
dossing93313273dossing
eosins64419163eo_sins
fails85631483f__ails
falsies103515013falsies
fascias1258413fascias
fesses94820253fess_es
fessing113812863fessing
fibrils1236843fibrils
fils75838693f___ils
fiscals1238003fiscals
fishily1637643fishily
fission1038733fission
fissions1138033fissions
flails94313003f_lails
floosies113210233floosies
flossers11307863flossers
flosses103411973floss_es
flossie10337443flossi_e
flossier11326973flossier
flossiest12296803flossiest
flossing12247903flossing
foals85721693fo__als
foamily1546543foamily
foggily1535053foggily
fogies104118063fo_gies
foil76433913fo__il_
foins85523383fo__ins
foisons1047613foisons
foists95413983fois_ts
folios93915463fo_lios
folkies143612253folkies
folksily1843443folksily
follies103618943follies
follis93113903folli_s
foodies113416753foodies
fools86824203fo__ols
footies103721543footies
footsies1139643footsies
forbids13268263forbids
foresails1247153foresails
formals123312893formals
formols12299413formols
formyls15235703formyls
forties104323863forties
fortis95418613forti_s
foss76431643fo_s__s
fossa85812633foss__a
fossae95510373foss_ae
fossate10388603fossate
fosse86119463foss__e
fossilised1452723fossilised
fossilises1343783fossilises
fossilize2143853fossilize
fossilizes2243903fossilizes
fosters104220103fosters
fouls87221433fo__uls
fowls115518893fo__wls
foxily1947253fo_xily
foxskins2242883foxskins
foxtails1844583foxtails
frails93716473f_rails
frazils1956123frazils
frostily1436693frostily
fulfils1345723fulfils
fusains1038363fusains
fusels94412453f_usels
fusil84715323f_usil_
fusile94313493f_usile
fussers104210813fussers
fusses94920553fuss_es
fussier103610673fussier
fussiest112910493fussiest
fussing113611683fussing
fustics1279593fustics
fustily133111373fustily
fuzils18407963f_uzils
gassily1137813gassily
glossies93311253glossies
glossily1235093glossily
gospels1035593gospels
gossans836783gossans
gossip946433gossi_p
gossipy1343953gossipy
gussies82813303gussies
hassels104311013hassels
hissies103915823hissies
horsily1338843horsily
hosels94218603ho_sels
hostels103712313hostels
hostile10312553hostile
hostiles11312213hostiles
housels105312133housels
hussies103213293hussies
instils7811453instils
jassids1586143jassids
josses135117683joss_es
lassies74420103lassies
lassis65216703lassi_s
losels64714583lo_sels
losses65925233loss_es
lousily1038333lousily
massifs1237743massifs
messily12298813messily
missals93914423missals
missels94614813missels
missies93423983missies
missile92815403missile
missiles103015083missiles
missis84417503missi_s
moils76125753mo__ils
morsels94112653morsels
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
ousels64815273_ousels
passels93913023passels
pastils94416173pastils
pensils92811593pensils
pistils93314303pistils
podsols1056513podsols
poesies93217403poesies
pontils9312213pontils
popsies112816463popsies
posies84431433po_sies
posits85718713po_sits
posses85128803poss_es
possess9419123possess
possets94212773possets
possible1245813possible
possibly1544483possibly
possums1145753possums
postals93716373postals
posties93128813posties
postins93721203postins
potsies93019483potsies
poussies1038113poussies
prossies101515223prossies
pussies93615693pussies
resails74616743resails
roils54826793ro__ils
roshis9311793roshi_s
rosily93914713ro_sily
rosins64521863ro_sins
sails55738103__sails
sassies74719263sassies
sassily1038723sassily
sessile739523sessile
sissies73716603sissies
soils55327983__soils
subfossils1551913subfossils
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.1531167915.0
2DLD Change Limit1340272466.89319443.9
3Display Results2462460.0932645.2
 (SQL Overall)1786912467.13925030.3
 
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.