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

113 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
cypreses153514(None) 
cypress1434651cypres_s
cypresses1645851cypresses
cypruses1534311cypruses
cyeses11510122cy__eses
cypres1338522cypr__es
impreses1238092impreses
anureses837973anureses
apheses12610703_apheses
apprises12310963apprises
apyrases1337243apyrases
asperses104111673asperses
bypasses1533833bypasses
capiases1239253capiases
capless114312763caples_s
caprices1439893caprices
caress85720263c_ares_s
caresses10314063c_aresses
carses85233653c_ar_ses
centeses1079443centeses
cereuses1049243c_ereuses
cerises94722253c_erises
ceruses93716233c_eruses
charases131312763charases
cheeses123613103c_heeses
choruses1339983choruses
citruses1037483citruses
compress1439053compres_s
compresses1647773compresses
comprises15510943comprises
copresent1349923copresent
copresents1446453copresents
copses104922473cop__ses
corpses113913803c_orpses
corpuses12310063corpuses
corses84433463c_or_ses
courses94218893cour_ses
crases85532313c__rases
creases94020963c__reases
creeses93914623c_reeses
cremes104517993c__remes
crepes105419343c__repes
cress75022833c__res_s
cresses94219813c__resses
crests85218703c__rests
crises84529433c__rises
cruses88127713c__ruses
cupreous1255603cupreous
cuprites1259023cuprites
curses85328273c_ur_ses
cyanoses1337423cyanoses
cybersex2241273cybersex
cycases1437533cy_cases
cyclases1537133cyclases
cycloses1538183cycloses
cyesis1148573cy__esis
cymenes1477413cy_menes
cyphered1934653cyphered
cyphers17316753cyphe_rs
cyprians1544213cyprians
cyprus1335363cypr__us
depress10239873depres_s
depresses1259883depresses
diereses938693diereses
diureses936453diureses
empress1138163empres_s
empresses1348163empresses
emprises12311003emprises
enureses838113enureses
express1637493expres_s
expresses1837863expresses
gyrases11368313gy_rases
gyrenes11267523gy_renes
hybrises1645423hybrises
hydrases15227643hydrases
hypnoses1646633hypnoses
impresas1244453impresas
imprese1138143imprese_
impress1137773impres_s
impresses1338213impresses
imprests1246313imprests
kyphoses2045283kyphoses
oppress1135993oppres_s
oppresses1346873oppresses
pareses94718883_pareses
perses85428063__perses
phereses1348093phereses
prases84429023__prases
prees75937173__pre_es
prese75228383__prese_
preset84430983__preset
presets94216423__presets
press75425953__pres_s
presses93523153__presses
prests84021263__prests
prexes154915953__prexes
prezes173614693__prezes
prises84133173__prises
proses84733473__proses
pyrenes123511223py_renes
pyrexes19305843py_rexes
repress92712683repres_s
represses11412143represses
reprises102615463reprises
sprees85620643_spre_es
supremes1238363supremes
syndeses1245263syndeses
synereses1245313synereses
typeset1267743typ_eset
typesets1343213typ_esets
typhuses1643763typhuses
uprises92012733_uprises
yeses85119323_y__eses

Search took 8 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.403443402.0
2DLD Change Limit1461621136.58022213.1
3Display Results1131130.0462456.5
 (SQL Overall)1786911137.02925422.0
 
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.