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

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

156 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
appeases123866(None) 
appease1137911appease_
appeased1335791appeased
appeaser1245951appeaser
appeasers1345261appeasers
apheses12610702aphe_ses
apophases1647972apophases
appealed1335602appealed
appealer1245742appealer
appealers1345062appealers
appeals11378672appea_ls
appeared1336142appeared
appears11308952appea_rs
applauses1344032applauses
apposes11511472app_oses
appraises1347422appraises
apprises12310962apprises
appulses1234892appulses
apyrases1337242apyrases
asperses104111672asperses
peases85229472__peases
pleases94515482_pleases
abases85720773a__bases
abbesses1235333abbesses
accesses1287493accesses
acreages1138373acreages
aliases7914493a_liases
amidases1136653amidases
amperages1447683amperages
amperes11313983ampe_res
amylases1346663amylases
anabases1038083anabases
anaphases1446523anaphases
anatases839793anatases
anlases72514903a_nlases
apanages1137013apanages
aperies9423203a_peries
apexes1539133a_pe_xes
aphereses1466423aphereses
aphesis12610513aphe_sis
apneas83211383apnea__s
apoapses1244713apoapses
apodoses1136653apodoses
apophasis1646993apophasis
apophyses1946113apophyses
apoptoses1346443apoptoses
appalls11337743app_alls
appals104812943app_a_ls
appanages1443993appanages
apparel1146003app_arel
apparels1245123app_arels
appeal103911613appea__l
appear10379343appea__r
appeasing1446343appeasing
appellee1246253appellee
appellees1344033appellees
appels104312793appe__ls
appendages1653243appendages
appended1435483appended
appends1236393appe_nds
appetiser1344443appetiser
appetisers1442933appetisers
appetites1347513appetites
applauds13103283applauds
applause1243663applause_
apples104315763app__les
applies11311213app_lies
appose10411993app_ose_
apposed1247853app_osed
apposer1147483app_oser
apposers1236283app_osers
appraise1247703appraise_
appraised1445593appraised
appraisee1345973appraisee
appraisees1443153appraisees
appraiser1344953appraiser
appraisers1443503appraisers
appressed1445943appressed
apprise11310193apprise_
apprised1337713apprised
appriser1246783appriser
apprisers1345053apprisers
apprizes2137793apprizes
approves15126833approves
appulse1134673appulse_
apses76823913a_p__ses
aptnesses11168993aptnesses
apyrase1236363apyrase_
arrases71214543a_rrases
asceses938623asce_ses
asepses946363a_sepses
askeses1136463aske_ses
asperates11312553asperates
asperges11318093asperges
asperse94210663asperse_
aspersed11428293aspersed
asperser10408303asperser
aspersers11377243aspersers
aspises9611643asp_ises
assesses737383assesses
atlases72410643a_tlases
auxeses1435623auxe_ses
avenses1049643a_venses
avgases11106313a_vgases
boreases10310253boreases
capiases1239253capiases
caseases10410473caseases
ceases84427073__ceases
copperases1644893copperases
creases94020963_creases
deceases11410153deceases
diseases92415813diseases
eases56041613___eases
emphases1568353emphases
epitases1038933epitases
expenses17138373expenses
feases95422923__feases
greases84816713_greases
lampases1267293lamp_ases
lamperses1345123lamperses
leases65428113__leases
lipases9209483lip_ases
miseases102614343miseases
opposes1149243opp_oses
oppresses1346873oppresses
papooses1248053papooses
pappooses1243993pappooses
pareses94718883pare_ses
pases75346503__p_ases
peaces106324083__peaces
peages94321853__peages
pease75231113__pease_
peasen84815963__peasen
peises84125043__peises
perses85428063__perses
phases114618403__phases
phrases12711463_phrases
pipeages1336423pipeages
please84315733_please_
pleased103712073_pleased
pleaser93912343_pleaser
pleasers104010293_pleasers
prases84429023__prases
presses93523153_presses
rappees113611453rappe__es
releases8313343releases
speises93813933_speises
spenses92913573_spenses
teases65426273__teases
typecases1643853typecases
unappeased1542623unappeased
uneases73316263_uneases
upases84112903_up_ases
upheaves1643913upheaves
uppercases1643423uppercases
ureases74416723_ureases

Search took 7 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 Filter1786911461620.406440125.6
2DLD Change Limit1461621566.48322545.4
3Display Results1561560.0632476.2
 (SQL Overall)1786911566.95225703.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.