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

171 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
cease7522765(None) 
case65848081c_ase
ceased94920781ceased
ceases84427071ceases
cense75121401cense
chase105127121chase
crease85519571crease
ease45042331_ease
fease84824871fease
lease55230261lease
pease75231111pease
tease55428711tease
abase76023482abase
base64847022_base
beast76338642beast
blase75524232blase
cade76443912c_ade
cafe95230322c_afe
cage75339062c_age
cake105439962c_ake
came87648752c_ame
cane66653122c_ane
cape87242782c_ape
care66968372c_are
carse74934332carse
casa65630862c_asa
casease939322casease
cased86032412c_ased
cases75048382c_ases
cash96636282c_ash
cask105626432c_ask
cast67159902c_ast
caste75932362c_aste
cate66254602c_ate
cause75225352cause
cave95941262c_ave
cede74928772ce_de
cedes84927332cedes
cee55952702ce__e
cees65941592cees_
cels65534972cels_
censed94016322censed
censer84516582censer
censes83721802censes
cepe84926652ce_pe
cepes94424462cepes
ceps86125952ceps_
cerate84829462cerate
cere66741472ce_re
ceres75540012ceres
cerise84822042cerise
ceruse83914522ceruse
cess65326052ce_ss
cessed94615612cessed
cesses84221362cesses
cetane8315282cetane
cete64934782ce_te
cetes75731102cetes
chafe135117352chafe
chaise114916412chaise
chape125221142chape
chare105231982chare
chased125019292chased
chaser114918382chaser
chases115128232chases
chasm125518792chasm
chasse115114602chasse
chaste114617392chaste
cheese113812762cheese
chose105925402chose
clade85821012clade
clash106219032clash
clasp95517192clasp
class75525482class
clast76030582clast
clause84311502clause
clave105420152clave
cleanse9358722cleanse
cleave114212512cleave
close76425222close
coarse84813902coarse
coast75236272coast
copse95623932copse
corse75036182corse
crake114823522crake
crane75331602crane
crape96128442crape
crases85532312crases
crash109120012crash
crass76328042crass
crate76537402crate
crave105626312crave
craze165221462craze
creased104315592creased
creaser94415742creaser
creases94020962creases
creasy114612302creasy
create85126382create
creese84014332creese
cruse75726102cruse
curse75829142curse
deash95617242deash
deave95022332deave
debase94014472debase
decease1049522decease
dense65923502dense
eased65430402_eased
easel54521112_easel
eases56041612_eases
east46659102_east
easy76224492_easy
eave75733582_eave
else45923082_else
erase54925492erase
feased105718712feased
feases95422922feases
feast85932722feast
feaze175216312feaze
fesse86116332fesse
geese64316002geese
grease75416232grease
hearse94114282hearse
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
teas45851492teas_
teased74721152teased
teasel63914982teasel
teaser65421522teaser
teases65426272teases
tense55225842tense
terse55026822terse
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.296603685.8
2DLD Change Limit538001711.61033416.1
3Display Results1711710.0463717.4
 (SQL Overall)1786911711.95291542.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.