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

65 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
kermesses1528496(None) 
kermesse14303481kermesse_
kirmesses15253901kirmesses
kermess13396222kerme_s_s
kermises14248312kerm_ises
permeases1347102permeases
berceuses1344103berceuses
burgesses1245513burgesses
caresses10314063car_esses
cereuses1049243cer_euses
cresses94219813_cr_esses
dearnesses1139583dearnesses
demesnes1137083de_mesnes
depresses1259883depresses
dermises112512023derm_ises
dresses83716173_dr_esses
duresses939173dur_esses
eerinesses10612603eerinesses
egresses949443_egresses
emeses86114963_e_me_ses
enmeshes1345343_enmeshes
excesses1736753_excesses
farnesses122310813farnesses
fewnesses1534953fewnesses
feynesses1535223feynesses
firmnesses1535613firmnesses
germinesses1437883germinesses
harnesses121812073harnesses
heiresses1236963heiresses
heresies11312693her_esies
karosses1236493kar_osses
keennesses1445323keennesses
keratoses1346093keratoses
kermes124616133kerm___es
kerosenes1345453kerosenes
kirmess13234313kirme_s_s
koumisses1552123koumisses
koumysses1841233koumysses
kumisses1443583k_umisses
largesses10246273largesses
messes84924343___messes
nearnesses1039103nearnesses
nemeses948663ne_me_ses
newnesses1236123newnesses
ogresses938473ogr_esses
peeresses1138473peeresses
percusses1346503percusses
permease1246503permease_
permeates13311773permeates
pertnesses12310313pertnesses
pertusses1145383pertusses
precesses13310463precesses
premisses13288763premisses
presses93523153_pr_esses
recesses10312323re_cesses
rednesses10312313rednesses
redresses10410293redresses
regresses10310463regresses
represses11412143represses
seeresses939053seeresses
skewnesses1743763skewnesses
stresses81112493str_esses
tresses73719543_tr_esses
warmnesses15167353warmnesses
wetnesses12208213wetnesses

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 Filter1786911486410.423422437.4
2DLD Change Limit148641657.26620457.1
3Display Results65650.0302166.7
 (SQL Overall)178691657.71923149.5
 
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.