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

152 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
fease8482487(None) 
cease75227651cease
ease45042331_ease
feased105718711feased
feases95422921feases
feast85932721feast
feaze175216311feaze
fesse86116331fesse
lease55230261lease
pease75231111pease
tease55428711tease
abase76023482abase
base64847022_base
beast76338642beast
blase75524232blase
case65848082_case
ceased94920782ceased
ceases84427072ceases
cense75121402cense
chase105127122chase
crease85519572crease
deash95617242deash
deave95022332deave
debase94014472debase
dense65923502dense
eased65430402_eased
easel54521112_easel
eases56041612_eases
east46659102_east
easy76224492_easy
eave75733582_eave
else45923082_else
erase54925492erase
face96140122f_ace
fade85736342f_ade
fake115534942f_ake
false84818122false
fame95639392f_ame
fane75343562f_ane
fare76354462f_are
fas68262932f_as_
fash107232292f_ash
fast77052312f_ast
fate75444282f_ate
fave105532962f_ave
faze165630042f_aze
feal713940422fea_l
fear75337792fea_r
feared106320432feared
fearer94820182fearer
fears84829392fears
feasted11310842feasted
feaster10812982feaster
feasts95116092feasts
feat76458222fea_t
feater95224052feater
feats86432752feats
feazed195112632feazed
feazes184514172feazes
feces105625362feces
feds85234312feds_
fee66862012fe__e
fees76450602fees_
feeze174913822feeze
fehs106522382fehs_
feist86230072feist
female11310552female
feme96130542fe_me
femes105626222femes
femme125011432femme
fems96428702fems_
fence105319912fence
fens76139762fens_
fere76342232fe_re
feres86038182feres
fes66551672fe_s_
fess76529162fe_ss
fessed104515062fessed
fesses94820252fesses
fest74949442fe_st
fetas85624402fetas_
fete75734922fe_te
fetes85630142fetes
fets75345942fets_
feus75830752feus_
fezes175220022fezes
flake125119972flake
flame105124442flame
flare84823632flare
flash115716212flash
flask125512422flask
fleas86423662fleas_
flense938902flense
fosse86119462fosse
frae75330472fra_e
fraise94214912fraise
frame105821802frame
frass85321122frass
frise85322452frise
fuse76429992f_use
geese64316002geese
grease75416232grease
hearse94114272hearse
heave114521812heave
jesse126012832jesse
keas86337092keas_
lase46148512_lase
leas45954182leas_
leased74722882leased
leaser65322672leaser
leases65428112leases
leash85519212leash
least56134882least
leave84723722leave
lense54523432lense
lyase85512412lyase
measle83513222measle
mense75025632mense
pase65346862_pase
peace95026082peace
peage84723562peage
peas65755062peas_
peasen84815952peasen
peases85229472peases
peise75825772peise
perse75429522perse
phase104617212phase
please84315732please
prase76128752prase
rase46149982_rase
reave84528022reave
reuse56025362reuse
seas45755272seas_
seise54727852seise
sense55526822sense
teas45851492teas_
teased74721152teased
teasel63914982teasel
teaser65421522teaser
teases65426272teases
tense55225842tense
terse55026822terse
ukase9428492ukase
unease63816642unease
urase54624682urase
urease64516992urease
vase75629652_vase
verse84723582verse
weasel93410522weasel
weave115218532weave
yeas78638422yeas_
yeast85327942yeast

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.0901985455.6
2DLD Change Limit538001521.48636204.6
3Display Results1521520.0463304.3
 (SQL Overall)1786911521.622110167.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.