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

191 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
compress143905(None) 
comfreys1843332comfreys
comparers15319392comparers
compares143816432compare_s
compass13379562comp_ass
compeers143410012compeers
compels133210882comp_els
comperes143217972comperes
composes145017112composes
compressed1745842compressed
compresses1647772compresses
compressor1644352compressor
comprise14310812comprise
comprises15510942comprises
congress1138072congress
cypress1434652c_ypress
decompress1742842decompress
empress1138162_empress
hotpress1344302hotpress
impress1137772_impress
oppress1135992_oppress
campers134220293camp_ers
campiest142212133campiest
campiness1537543campiness
camporees1546103camporees
campuses1437773campuses
capless114312763c_apless
caress85720263c__aress
cateress102311613cateress
chompers17369593chomp_ers
coalless1038193coalless
coatdress1243193coatdress
coatless1039693coatless
codeless112010113codeless
coffrets1645363coffrets
coheiress1443353coheiress
coherers132310733coherers
coheres122917693cohere_s
coldness1137953coldness
coloreds1138093coloreds
colorers10312183colorers
colorless1145683colorless
colures9315143colure_s
comakers16339173comakers
comakes154413643comake_s
comates114123643comate_s
combers134516623com_bers
combes125321733com_be_s
comers105328083com__ers
comes97246993com__e_s
comets105823583com__ets
comfiest1539133comfiest
comfiness1646953comfiness
comfrey1734683comfre_y
commies133718453commie_s
compacts16368903compacts
compadres16266413compadre_s
compare135814993compare__
compared153811823compare_d
comparer143611363compare_r
comparts144210833comparts
compas125817063comp__as
compasses1547393compasses
comped135919873comp_e_d
compeer133811553comp_eer
compel124412893comp_e_l
compend144010303comp_end
compends15378253compends
compere134616623comp_ere
compered153414923compered
compete134716553comp_ete
competes144117243competes
compilers1537053compilers
compiles14311983compiles
compleat14710153compleat
complect1659013complect
complects1766413complects
complete143412053complete
completes153212923completes
complex2037243comple_x
complexes22308103complexes
compliers1538293compliers
complies14314523complies
complins14313113complins
complots1438163complots
comports143411983comports
compos124818803comp__os
compose135716663comp_ose
composed154612063composed
composer145012953composer
composers153910623composers
compost134515353comp_ost
composts144210913composts
compotes144716513compotes
compressing1846433compressing
compression1756563compression
compressive2055303compressive
compressors1754193compressors
comprisal1544513comprisal
comprisals1643703comprisals
comprised1648053comprised
comprize2368733comprize
comprizes2468943comprizes
comps115526053comp___s
compted143813523compte_d
compts125216653comp__ts
computers15339753computers
computes143914553computes
comtes106222813com_te_s
confess12399903co_nfess
cookless14258633cookless
coolness1037743coolness
coopers114019483coop_ers
copens106119963co_p_ens
copers104629843co_p_ers
copes97747103co_p_e_s
copiers114215963co_piers
copies104130303co_pie_s
copperas14308573copperas
coppers133519753co_ppers
coppras13327833coppr_as
coprahs14338153co_prahs
copras103517153co_pr_as
copses104922473co_pse_s
copters113621283co_pters
cordless11299963cordless
coreless103013833coreless
corers85231073co__rers
cores76361853co__re_s
corpses113913803corpse_s
corpuses12310063corpuses
corses84433463co__rses
cosiness103214283cosiness
costless10310003costless
costrels1038933costrels
countess103710053countess
coupes105022523coup_e_s
couplers123311323couplers
couples115317053couple_s
couplets12389873couplets
courses94218893co_urses
coverers132712123coverers
coverless1436803coverless
cowpeas1437273cowp_eas
cowpies143314283cowpie_s
coxless1637743co_xless
coyness1277323co_yness
coziness19319823coziness
cress75022833c___ress
cropless1237793cropless
cypres1338523c_ypre_s
cypreses1535143c_ypreses
dampness1336073dampness
depress10239873_depress
express1637493_express
fortress1136753fortress
gomerels1144563gomerels
hombres14369873hombre_s
homeless131110133homeless
hominess132712453hominess
hoopless13279263hoopless
humpless15226333humpless
impresa1134753_impresa
impresas1244453_impresas
imprese1138143_imprese
impreses1238093_impreses
imprest11310203_imprest
imprests1246313_imprests
koupreys1741733koupreys
lampreys1542883lampreys
limpness1246703limpness
ogress7529503_o_gress
ombres103911143_ombre_s
ospreys1233143_ospreys
outpress10118183outpress
pomfrets1543033pomfrets
portress1038323portress
prepress12137983prepress
press75425953___press
pumpless14236373pumpless
repress92712683_repress
rompers113412243romp_ers
rumpless12256543rumpless
soapless10278073soapless
soupless10268463soupless
suppress1236443suppress
temptress1343133temptress
tombless1236783tombless
topless92511123to_pless
votaress1144223votaress
votress1035483vo_tress

Search took 9 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.420425454.8
2DLD Change Limit1461621917.61019206.6
3Display Results1911910.0633031.7
 (SQL Overall)1786911918.09322079.7
 
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.