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

300 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
fossae9551037(None) 
fossa85812631fossa_
fossas94610701fossas
fossate10388601fossate
fosse86119461foss_e
costae85319682costae
dossal75510302dossal
fesse86116332fess_e
fissate103010032fissate
flossie10337442flossie
forsake1436532forsake
foss76431642foss__
fosses96022082fosses
fossil9379352fossil
foveae1237562foveae
glossae8477282glossae
gossan747232gossan
ossa43714162_ossa_
posse74722272poss_e
ansae55720973_ansae
aortae65115473aortae
assai5711543_assai
assay8710283_assay
bonsai838463bonsai
boscage1276533boscage
boskage1465413boskage
bosque17257733bosque
boss65938343boss__
bossed94816533bossed
bosses85925403bosses
bossier93712423bossier
bossies94116833bossies
bossy105515973boss_y
bouse75931853bous_e
bowse105420633bows_e
bursae84515603bursae
byssal1134993byssal
comae97128423co_mae
copse95623923cops_e
corsac10410173corsac
corsage1039803corsage
corse75036183cors_e
cosie74728263co_sie
cosine83823513cosine
coss66143493coss__
cossack1545823cossack
cosset84125863cosset
costa75523733costa_
costal85419513costal
costar85518613costar
costate94019273costate
cottae84615703cottae
coxae146115183co_xae
crosse85216303cross_e
dassie74615573dassie
dissave1139413dissave
donsie7613643donsie
dorsa64617283dorsa_
dorsad8408973dorsad
dorsal74613943dorsal
dosage82810003dosage
dose56442433do_s_e
doss56235043doss__
dossals8379293dossals
dossed84516633dossed
dossel74813643dossel
dosser74417973dosser
dosses76126273dosses
dossier83711693dossier
dossil75110903dossil
douse66329723dous_e
dowse96020813dows_e
eosine64519413eosine
essay867623_essay
faciae112913413faciae
false84818123fals_e
falsie93513853falsie
fasciae1247523fasciae
faunae95210373faunae
fease84824873feas_e
feriae95618603feriae
fescue1137493fescue
fess76529163fess__
fessed104515063fessed
fesses94820253fesses
festal94213563festal
fiscal1139333fiscal
fissile10269653fissile
fissure1036783fissure
floosie10378933floosie
florae94713883florae
floss85118263floss__
flossed11388533flossed
flosser10339693flosser
flosses103411973flosses
flossier11326973flossier
flossies112810123flossies
flossy12517703floss_y
flotsam1244613flotsam
foal76630923fo__al
foam97127173fo__am
fobs96034273fobs__
focal104917673fo_cal
foe66350813fo___e
foeman11311233foeman
foes76543443foes__
foetal9311883foetal
foggage1334113foggage
fogie96719003fo_gie
fogs87035003fogs__
foible11410383foible
foison948933foison
foist85730973fois_t
foisted113210603foisted
foists95413983foists
folate93320393folate
folia83618933folia_
foliage1147533foliage
foliar93210973foliar
foliate10513533foliate
folkie13369613folkie
fomite113314073fomite
fondle104412943fondle
fondue104510493fondue
fons76943893fons__
fontal9313143fontal
foodie104413843foodie
footage1148843footage
footie94718133footie
footle93914383footle
footsie1047643footsie
foozle18369203foozle
fops96532683fops__
fora75937393fo_ra_
forage104617003forage
foram105124933fo_ram
foray115023973fo_ray
forbad122710503forbad
forbade13259103forbade
forbare122310513forbare
forbye14427883forbye
force105324273fo_rce
fore78351473fo__re
foresaw1377133foresaw
foresee10414333foresee
forgat104018583forgat
forgave1435853forgave
forge95126943fo_rge
formal113215203formal
format113021353format
formate123115093formate
forme105225993fo_rme
formee113919943formee
forsaken1543353forsaken
forsaker1545103forsaker
forsakes1536893forsakes
forte86131463fo_rte
fossette1145263fossette
fossick16134733fossick
fossils10379013fossils
foster94322223foster
fovea11310483fovea_
foveal1237703foveal
foveas1238623foveas
foveate1338363foveate
foys105628293foys__
frae75330473f__rae
frise85322453fris_e
frisee94217993frisee
fuse76429993f_us_e
fusee86224583f_usee
fusile94313493fusile
fuss76027933fuss__
fussed104613803fussed
fusser94813773fusser
fusses94920553fusses
fussier103610673fussier
fussy115613953fuss_y
glossa7529163glossa_
glossal8447053glossal
glossas8438193glossas
goose65925903goos_e
gorse65926813gors_e
gossamer1143633gossamer
gossans836783gossans
gossip946433gossip
gussie72910153gussie
hassle93711593hassle
hoise85224773hois_e
horse86132653hors_e
horste94817413horste
hose76547243ho_s_e
hosta85917833hosta_
hostage113111233hostage
hostas94515823hostas
house89131423hous_e
hussar9317283hussar
issue559213_issue
jesse126012833jess_e
joss115925593joss__
josses135117683josses
jostle13319863jostle
koss85224813koss__
lassie64917743lassie
lessee64116363lessee
loessal744393loessal
loose56627683loos_e
lose45144583lo_s_e
loss45337963loss__
losses65925233losses
lossy85214643loss_y
louse56131013lous_e
lowse87219903lows_e
lyssa835713lyssa_
lyssas935443lyssas
massa75518923massa_
massage1039893massage
massas85116463massas
masse75125293mass_e
mensae84114043mensae
message1037833message
messan83912063messan
missal84314903missal
missay114112143missay
moose76327193moos_e
morae75831193mo_rae
morse76032703mors_e
moshav1446053moshav
mosque17287163mosque
moss67641033moss__
mossed94818893mossed
mosser84618273mosser
mosses85527683mosses
mossier94413813mossier
mosso74715183moss_o
mossy105217063moss_y
moste75925083mo_ste
mouse77133003mous_e
mousse84813033mousse
muscae10410673muscae
noise55723733nois_e
noose55624063noos_e
nose46739363no_s_e
novae85913123no_vae
osar46820953_o_sar
ose38147343_o_s_e
ossia53710403_ossia
owse76321623_ows_e
passade1039233passade
passage1039803passage
passe75525693pass_e
passee84522023passee
poise75127893pois_e
popsie103013053popsie
pose66441733po_s_e
posole8314223posole
posses85128803posses
posset84923253posset
possum1057953possum
postage103214853postage
postal84317533postal
postie84123963postie
potsie83916023potsie
poussie936623poussie
prossie91812953prossie
psoae74411623_psoae
rassle63813203rassle
roose56127093roos_e
roscoe839763roscoe
rose46148903ro_s_e
roseate7613453roseate
rouse56634703rous_e
sae38365183___sae
sonsie6614853sonsie
souse56530773sous_e
spae65034323__spae
tasse54821843tass_e
tassie66017023tassie
testae64216253testae
tissue637333tissue
togae67020113to_gae
torsade837593torsade
torse55833333tors_e
toss45637973toss__
tossed74215223tossed
tosser64215663tosser
tosses65225393tosses
tossup875293tossup
touse55430673tous_e
tousle64514653tousle
tussah9356233tussah
tussal6288323tussal
tussar6369543tussar
tussle637143tussle
ursae55214453_ursae
vassal979243vassal
worse86525263wors_e
youse85322233yous_e
zoeae144412483zo_eae
zonae145116443zo_nae

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 Filter1786911127160.1431249587.4
2DLD Change Limit1127163007.12315824.2
3Display Results3003000.1901578.9
 (SQL Overall)1786913007.45623966.1
 
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.