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

174 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
teases6542627(None) 
ceases84427071ceases
eases56041611_eases
feases95422921feases
leases65428111leases
peases85229471peases
tease55428711tease_
teased74721151teased
teasel63914981teasel
teasels74311311teasels
teaser65421521teaser
teasers75317241teasers
tenses64722551tenses
texases1437571texases
abases85720772abases
atlases72410642atlases
baases85218012baases
bases75644352_bases
beasts84519722beasts
beses75830722be_ses
biases84618432biases
cases75048382_cases
cease75227652cease_
ceased94920782ceased
censes83721802censes
cesses84221362cesses
chases115128232chases
crases85532312crases
creases94020962creases
deashes113313902deashes
deaves105319532deaves
debases103814132debases
degases93413102degases
ease45042332_ease_
eased65430402_eased
easel54521112_easel
easels65914552_easels
easies64126632_easies
easts57530322_easts
eaves85231992_eaves
erases64425402erases
erses55826802_erses
eses45336102_e_ses
esses56422972_esses
etapes85415292etapes
eyases94513682eyases
fease84824872fease_
feased105718712feased
feasts95116092feasts
feazes184514172feazes
fesses94820252fesses
gases65633992_gases
greases84816712greases
hearses104414532hearses
heaves124120302heaves
jesses135215952jesses
kvases13467102kvases
lases54944762_lases
lease55230262lease_
leased74722882leased
leaser65322672leaser
leasers74717842leasers
leashes103514402leashes
leasts64616412leasts
leaves94222382leaves
lenses64620892lenses
leses54930812le_ses
lyases95211872lyases
measles92412752measles
menses84222452menses
messes84924342messes
myases113711552myases
nesses64718322nesses
oases55330982_oases
pases75346502_pases
peaces106324082peaces
peages94321852peages
pease75231112pease_
peasen84815962peasen
peises84125042peises
perses85428062perses
phases114618402phases
pleases94515482pleases
prases84429022prases
rases55447212_rases
reales64934122reales
reaves94127572reaves
reuses66025522reuses
seises64026712seises
senses63923942senses
sepses84515882sepses
stases64225562stases
tabes76033922t_abes
taces76237802t_aces
tajes124920692t_ajes
takes94437792t_akes
tales55451372t_ales
tames75242012t_ames
tapes75838602t_apes
tares57456562t_ares
tasks94917582t_asks
tass45640572t_as_s
tasse54821842t_asse
tasses64826762tasses
tastes64126422t_astes
tates55444982t_ates
tawses94913192tawses
taxes124730822t_axes
teaches122718352teaches
teaks94222902tea_ks
teals56234132tea_ls
teamed95418592teamed
teams75726512tea_ms
teared75722152teared
tearer64822902tearer
tearers75218232tearers
tears55436462tea_rs
teas45851492tea__s
teated74924022teated
teats55636812tea_ts
teazel15368542teazel
teazels16406892teazels
teazles16308922teazles
tees45353582te__es
teles54536002te_les
teleses7313122teleses
tenaces92814512tenaces
teniases838622teniases
tense55225842tense_
tensed74817832tensed
tenser64919432tenser
tensest72713312tensest
tenues63816442tenues
tepees84215242tepees
terces83921412terces
ternes65422902ternes
terrases82111482terrases
terse55026822terse_
terser67317822terser
tersest71713992tersest
testes65125822testes
tests56530192te_sts
thanes94918982thanes
theses96517972theses
tmeses85712242tmeses
toasts65914992toasts
torses64727952torses
tosses65225392tosses
touses64229672touses
traces85329932traces
trades75724502trades
trapes85024462trapes
trashes104119262trashes
trass56226472tras_s
trasses74819322trasses
traves94222742traves
tresses73719542tresses
tsades74310992tsades
tsetses785452tsetses
tusses64921242tusses
twaes86513662twa_es
ukases10358062ukases
uneases73316262uneases
upases84112902upases
urases63723562urases
ureases74416722ureases
vases84626262_vases
verses94223762verses
weasel93410522weasel
weasels10468502weasels
weaves123616372weaves
yeasts96413052yeasts
yeses85119322ye_ses
yesses93615812yesses

Search took 3 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 Filter178691825510.343520965.0
2DLD Change Limit825511742.23336968.7
3Display Results1741740.0632761.9
 (SQL Overall)1786911742.63967711.6
 
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.