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

59 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
creepinesses164525(None) 
breezinesses2343942breezinesses
cheekinesses2164202cheekinesses
cheerinesses1765822cheerinesses
cheesinesses1765372cheesinesses
creakinesses1845982creakinesses
creaminesses1646122creaminesses
creepiness1444882creepine_s_s
crispinesses1645002crispinesses
greedinesses1446452greedinesses
preppinesses1544872preppinesses
reedinesses1259552_reedinesses
sleepinesses1445672sleepinesses
weepinesses1646132_weepinesses
beefinesses1675953_beefinesses
beerinesses1398913_beerinesses
campinesses1737113c_ampinesses
cheapnesses18104023cheap_nesses
chewinesses1945143c_hewinesses
choppinesses2143353choppinesses
comelinesses1666393comelinesses
craftinesses1746373craftinesses
cragginesses1644503cragginesses
crankinesses1846143crankinesses
crazinesses2237923cr_azinesses
crispnesses1545943crisp_nesses
cruelnesses1346243crue_lnesses
crumminesses1843653crumminesses
crustinesses14137613crustinesses
deepnesses1366673_deep_nesses
dreaminesses1545703dreaminesses
drearinesses1347433drearinesses
dressinesses1245523dressinesses
eerinesses10612583__eerinesses
freakinesses1945583freakinesses
freenesses1339863free__nesses
geekinesses1635813_geekinesses
grapinesses1438563gr_apinesses
greasinesses1347033greasinesses
greennesses1247023gree_nnesses
grumpinesses1743663grumpinesses
leerinesses11119473_leerinesses
needinesses1258103_needinesses
ornerinesses1246553ornerinesses
peppinesses1435313_peppinesses
prettinesses1447513prettinesses
raspinesses1338013_raspinesses
readinesses12611263_readinesses
ropinesses121311023_r_opinesses
scrappinesses1952293scrappinesses
screwinesses1744743scr_ewinesses
seedinesses1259203_seedinesses
speedinesses1545593speedinesses
steelinesses1246723steelinesses
steepnesses1345923steep_nesses
trendinesses1346323trendinesses
tweedinesses1643613tweedinesses
weedinesses1557073_weedinesses
wheezinesses2742863wheezinesses

Search took 5 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 Filter178691950240.1261418182.5
2DLD Change Limit95024594.18622700.4
3Display Results59590.0461282.6
 (SQL Overall)178691594.35841003.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.