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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

51 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
compressed174584(None) 
compresses1647771compresses
compassed1645542comp_assed
compress1439052compress__
compressedly2252162compressedly
compressor1644352compressor
comprised1648052compr_ised
congressed1445462congressed
decompressed20102422decompressed
hotpressed1643142hotpressed
impressed1446282_impressed
oppressed1445122_oppressed
appressed1445943_appressed
caressed1139163c__aressed
compasses1547393comp_asses
compeered1646303comp_eered
compelled1646133comp_elled
compered153414923comp_e_red
competed154113593comp_e_ted
complected19295863complected
completed162810263comple_ted
complexed23295973comple_xed
composed154612063comp__osed
composted16378813comp_osted
comprehend2073943comprehend
compressing1846433compressing
compression1756563compression
compressive2055303compressive
compressors1754193compressors
comprise14310813compr_ise_
comprises15510943compr_ises
comprized2567223compr_ized
compromised2052773compromised
confessed1546053co_nfessed
congresses1348023congresses
cypresses1645853c_ypresses
decompresses1972823decompresses
depressed1357623_depressed
empresses1348163_empresses
expressed1946213_expressed
fortressed1443583fortressed
hotpresses1544523hotpresses
impresses1338213_impresses
nonprossed1353553nonprossed
oppresses1346873_oppresses
outpressed13126153outpressed
pressed103317313___pressed
repressed12610103_repressed
suppressed1544533suppressed
unimpressed1652693unimpressed
unpressed1237953_unpressed

Search took 6 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 Filter1786911406030.1531167915.0
2DLD Change Limit140603515.75024452.7
3Display Results51510.0163187.5
 (SQL Overall)178691515.91930189.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.