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

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
cypress143465(None) 
cypres1338521cypre_s
cypreses1535141cypreses
capless114312762capless
caress85720262c_aress
compress1439052compress
cress75022832c__ress
cyphers17316752cyphers
cypresses1645852cypresses
cyprus1335362cypr_us
cypruses1534312cypruses
depress10239872depress
empress1138162empress
express1637492express
impress1137772impress
oppress1135992oppress
press75425952__press
repress92712682repress
actress948533actress
address956103address
aggress935593aggress
ancress978613ancress
apres75426403_apre_s
bypass1345043byp_ass
byres104421383by_re_s
cadres94017933cadre_s
caperers122611723caperers
capers105428143cap_ers
capes95441923cap_e_s
caplets114914523caplets
cappers134419403cappers
capris10415083capr_is
carers85133963c_arers
cares77369183c_are_s
carets85330773c_arets
carless95118493carless
carpels115315463carpels
carpers114521253carpers
carpets113915333carpets
carrels95117303carrels
carses85233653c_arses
cateress102311613cateress
cepes94424463cep_e_s
ceres75540013c_ere_s
cereus85215523c_ereus
cess65326053c___ess
chares115631803chare_s
chess105016923c__hess
choreas124414203choreas
chores114828023chore_s
ciphers14379993ciphers
cires74932913c_ire_s
clarets94111103clarets
clypeus1433243clyp_eus
confess12399903confess
congress1138073congress
copens106119963cop_ens
copers104629843cop_ers
copes97747103cop_e_s
copiers114215963copiers
copies104130303copie_s
coppers133519753coppers
coprahs14338153coprahs
copras103517153copr_as
copses104922473copse_s
copters113621283copters
corers85231073c_orers
cores76361853c_ore_s
corpses113913803corpses
corses84433463c_orses
courses94218893courses
coxless1637743coxless
coyness1277323coyness
crass76328043c__rass
creds85418773c__reds
cressy11439113c__ressy
crest74632693c__rest
crests85218703c__rests
crews105917503c__rews
cropless1237793cropless
crores86121163crore_s
cross75124503c__ross
cuirass934973cuirass
cupels10310203cup_els
cuppers133712213cuppers
cupreous1255603cupreous
cuprous1149743cuprous
cuprums1334453cuprums
curers84923193c_urers
cures75645433c_ure_s
curets84922343c_urets
curses85328273c_urses
cycases1437533cycases
cyclers1435873cyclers
cycles1339303cycle_s
cyders12398833cy_ders
cyeses11510123cy__eses
cyesis1148573cy__esis
cygnets1333813cygnets
cymes1210118923cy_me_s
cypher16306593cyphe_r
cyprian1445343cyprian
cyprians1544213cyprians
cypsela1442443cypsela
digress938323digress
dress65319833__dress
duress74712063_duress
egress73310433_egress
eldress835003eldress
espresso1043193espresso
expresso1743883expresso
eyeless1058053eyeless
eyres84921773ey_re_s
gapless10349993gapless
gyppers15235503gyppers
gyres94820323gy_re_s
hapless123311333hapless
heiress1036813heiress
hipless12399923hipless
hipness12277383hipness
hotpress1344303hotpress
hypers144811913hyp_ers
hypes135818673hyp_e_s
hyphens1836043hyphens
impresa1134753impresa
impresas1244453impresas
imprese1138143imprese
impreses1238093impreses
imprest11310203imprest
imprests1246313imprests
ingress838653ingress
lipless9259553lipless
lyres85019963ly_re_s
mayoress1344383mayoress
napless93110283napless
ogress7529503_ogress
ospreys1233143ospreys
outpress10118183outpress
peeress939503peeress
prees75937173__prees
prepress12137983prepress
preps96220693__preps
presa74319043__presa
prese75228383__prese
prest75736353__prest
prests84021263__prests
preys105717783__preys
priss74623893__priss
pross76529403__pross
pyres105523883py_re_s
redress82511873redress
regress82711453regress
sapless93313443sapless
seeress7311573seeress
sprees85620643_sprees
stress66616673_stress
suppress1236443suppress
syphers15317273syphers
syrens94911993sy_rens
tigress836093tigress
tipless92610063tipless
topless92511123topless
tress55423163__tress
types105721063typ_e_s
typiest1238203typiest
tyres84725233ty_re_s
undress838893undress
votress1035483votress
yarest95018913_yarest
yores85031323_yore_s
zipless18276303zipless

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 Filter1786911340270.563317390.8
2DLD Change Limit1340271716.36021073.4
3Display Results1711710.0632714.3
 (SQL Overall)1786911716.98625578.4
 
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.