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

164 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
tease5542871(None) 
cease75227651cease
ease45042331_ease
fease84824871fease
lease55230261lease
pease75231111pease
teas45851491teas_
teased74721151teased
teasel63914981teasel
teaser65421521teaser
teases65426271teases
tense55225841tense
terse55026821terse
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
etape74413702etape
etas46432272etas_
feased105718712feased
feases95422922feases
feast85932722feast
feaze175216312feaze
fesse86116332fesse
geese64316002geese
grease75416232grease
hearse94114272hearse
heave114521812heave
jesse126012832jesse
keas86337092keas_
lase46148512_lase
leas45954182leas_
leased74722882leased
leaser65322672leaser
leases65428112leases
leash85519212leash
least56134882least
leave84723722leave
lense54523432lense
lyase85512412lyase
measle83513222measle
mense75025632mense
pase65346862_pase
peace95026082peace
peage84723572peage
peas65755062peas_
peasen84815962peasen
peases85229472peases
peise75825772peise
perse75429522perse
phase104617212phase
please84315732please
prase76128752prase
rase46149982_rase
reave84528022reave
reuse56025362reuse
seas45755272seas_
seise54727852seise
sense55526822sense
tace65342512t_ace
tae38267052t_a_e
take84739262t_ake
tale46154162t_ale
tame66343662t_ame
tape64538142t_ape
tare45957622t_are
tas38477102t_as_
task85326652t_ask
tass45640572t_ass
tasse54821842tasse
taste55127232t_aste
tate44748602t_ate
tawse85616502tawse
tea37353322tea__
teach105221122teach
teak85930842tea_k
teaks94222902teaks
teal45546502tea_l
teals56234132teals
team66238652tea_m
teamed95418592teamed
teams75726512teams
tear45242882tea_r
teared75722152teared
tearer64822902tearer
tears55436462tears
teary85124052teary
teasels74311312teasels
teasers75317242teasers
teat45963632tea_t
teated74924022teated
teats55636812teats
teazel15368542teazel
teazle15329552teazle
teds54932572teds_
tee38366872te__e
tees45353582tees_
tegs56031492tegs_
telae54323292telae
tele45040872te_le
teles54536002teles
tels46841692tels_
tenace82715692tenace
tenge65720442tenge
tens45647412tens_
tensed74817832tensed
tenser64919432tenser
tenses64722552tenses
tepas76521682tepas_
tepee74724212tepee
terce75721842terce
terne56426152terne
terser67317822terser
test48651622te_st
tets45847462tets_
tews76431642tews_
texas126514932texas_
texases1437572texases
thae76825562tha_e
thane86122532thane
these86519012these
those85218142those
toast55831012toast
toeas55726422toeas_
torse55833332torse
touse55430672touse
trace75829612trace
trade65026042trade
trash86119762trash
trass56226472trass
trave85223032trave
tsade64311122tsade
tsetse664692tsetse
twae74719572twa_e
twaes86513662twaes
twas76824082twas_
ukase9428492ukase
unease63816642unease
urase54624692urase
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.300595636.7
2DLD Change Limit538001641.43637465.2
3Display Results1641640.0463565.2
 (SQL Overall)1786911641.782100275.5
 
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.