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 “fosse” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

128 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
fosse8611946(None) 
fesse86116331fesse
foss76431641foss_
fossa85812631fossa
fossae95510371fossae
fosses96022081fosses
posse74722271posse
boss65938342boss_
bossed94816532bossed
bosses85925402bosses
bossy105515972bossy
bouse75931852bouse
bowse105420632bowse
copse95623922copse
corse75036182corse
coses76949492coses
cosie74728262cosie
coss66143492coss_
cosset84125862cosset
crosse85216302crosse
dose56442432do_se
doses65938502doses
doss56235042doss_
dossed84516632dossed
dossel74813642dossel
dosser74417972dosser
dosses76126272dosses
douse66329722douse
dowse96020812dowse
false84818122false
fease84824872fease
fess76529162fess_
fessed104515062fessed
fesses94820252fesses
floss85118262floss_
flossed11388532flossed
flosser10339692flosser
flosses103411972flosses
flossie10337442flossie
flossy12517702flossy
fobs96034272fobs_
foe66350812fo__e
foes76543442foes_
fogie96719002fogie
fogs87035002fogs_
foist85730972foist
fons76943892fons_
fops96532682fops_
force105324272force
fore78351472fo_re
fores85847102fores
forge95126942forge
forme105225992forme
forte86131462forte
fossas94610702fossas
fossate10388602fossate
fossil9379352fossil
foster94322222foster
foxes156321092foxes
foys105628292foys_
frise85322452frise
fuse76429992f_use
fusee86224582fusee
fuses85628422fuses
fuss76027932fuss_
fussed104613802fussed
fusser94813772fusser
fusses94920552fusses
fussy115613952fussy
goose65925902goose
gorse65926812gorse
hoise85224772hoise
horse86132652horse
hose76547242ho_se
hoses85443172hoses
house89131422house
jesse126012832jesse
joss115925592joss_
josses135117682josses
koss85224812koss_
loose56627682loose
lose45144582lo_se
loses56742012loses
loss45337962loss_
losses65925232losses
lossy85214642lossy
louse56131012louse
lowse87219902lowse
masse75125292masse
moose76327192moose
morse76032702morse
moss67641032moss_
mossed94818892mossed
mosser84618272mosser
mosses85527682mosses
mosso74715182mosso
mossy105217062mossy
moste75925082moste
mouse77133002mouse
mousse84813032mousse
noise55723732noise
noose55624062noose
nose46739362no_se
noses55435642noses
ose38147342_o_se
oses46641512_oses
ossa43714162_ossa
owse76321622_owse
passe75525692passe
poise75127892poise
pose66441732po_se
poses74642762poses
posses85128802posses
posset84923252posset
roose56127092roose
rose46148902ro_se
roses56445772roses
rouse56634702rouse
souse56530772souse
tasse54821842tasse
torse55833332torse
toss45637972toss_
tossed74215222tossed
tosser64215662tosser
tosses65225392tosses
touse55430672touse
worse86525262worse
youse85322232youse

Search took 2 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 Filter178691538000.310576422.6
2DLD Change Limit538001281.58034050.6
3Display Results1281280.0304266.7
 (SQL Overall)1786911281.92093068.2
 
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.