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

119 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
cypruses153431(None) 
cypreses1535141cypreses
ceruses93716232c_eruses
choruses1339982choruses
citruses1037482citruses
corpuses12310062corpuses
cruses88127712c__ruses
cypres1338522cypr__es
cypress1434652cypres_s
cypresses1645852cypresses
cyprus1335362cypru__s
typhuses1643762typhuses
apprises12310963apprises
apyrases1337243apyrases
bypasses1533833bypasses
byssuses1342273byssuses
cactuses1237933cactuses
calluses1039323calluses
campuses1437773campuses
capiases1239253capiases
caprices1439893caprices
capsules1236623capsules
captures1239443captures
carouses10614503carouses
carses85233653c_ar_ses
caucuses1236783caucuses
causes88026473c__auses
cayuses12188403c_ayuses
censuses10187543censuses
cereuses1049243cereuses
cerises94722253c_erises
ceruse83914523c_eruse_
cestuses1038083cestuses
charases131312763charases
chiauses1336483chiauses
chorused1446133chorused
chorusses1444883chorusses
chouses125117813c_houses
circuses1238253circuses
cistuses1038283cistuses
clauses93813323c_lauses
clonuses1057133clonuses
coituses1039623coituses
coleuses1039723coleuses
comprises15510943comprises
confuses13310363confuses
contuses10413453contuses
copses104922473cop__ses
cornuses10310033cornuses
corpses113913803c_orpses
corses84433463c_or_ses
courses94218893cour_ses
crases85532313c__rases
crises84529433c__rises
crocuses1239023crocuses
cruces105117543c__ruces
crudes96218623c__rudes
cruises93514443c__ruises
cruse75726103c__ruse_
cruset84425093c__ruset
crusets93811043c__rusets
crushes124215133c__rushes
crusts84916543c__rusts
cruxes154911563c__ruxes
cultuses1037753cultuses
cuprites1259023cuprites
cuprums1334453cupru_ms
cupules113210263cup_ules
curses85328273c_ur_ses
cuscuses1235863cuscuses
cutpurses1343313cutpurses
cyanoses1337423cyanoses
cycases1437533cy_cases
cyclases1537133cyclases
cycloses1538183cycloses
cyeses11510123cy__eses
cyprians1544213cyprians
druses75517253__druses
emprises12311003emprises
espouses1037303espouses
estruses838483estruses
gyplures14102153gyplures
gyrases11368313gy_rases
hybrises1645423hybrises
hydrases15227643hydrases
hypnoses1646633hypnoses
icteruses1144973icteruses
impreses1238093impreses
kyphoses2045283kyphoses
lupuses936273lup_uses
opuses84012243_op_uses
overuses11312643overuses
papyruses1643223papyruses
pauses84621473__pauses
pepluses1287023pepluses
peruses94018163_peruses
pluses83618073__pluses
prases84429023__prases
prises84133173__prises
proses84733473__proses
prudes94215443__prudes
prunes83419063__prunes
purses84826373__purses
puses75532203__p_uses
pyloruses1443813pyloruses
reprises102615463reprises
ruses56136583___ruses
spouses92912813_spouses
spruces113810503_spruces
sprues84515763_spru_es
uprises92012733_uprises
uprouses1037553_uprouses
uprushes13194863_uprushes
uruses63616503__uruses
uteruses837183uteruses
varuses10310623_varuses
viruses1039413_viruses
walruses11554973walruses
xeruses143010753_xeruses

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.423422437.4
2DLD Change Limit1461621196.89021213.6
3Display Results1191190.0462587.0
 (SQL Overall)1786911197.35924282.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.