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

101 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
gneisses93367(None) 
geniuses935932geniuses
gneiss765952gnei_s_s
gneissic1162042gneissic
gneissose1051172gneissose
guesses8169372gue_sses
nesses64718322_ne_sses
speisses10245692speisses
anemoses10159433anemoses
anises64826693an_i_ses
bekisses1434243bekisses
bignesses1267963bigne_sses
blesses93812393ble_sses
blisses94911513_blisses
brisses94314313_brisses
cesses84221363_ce_sses
chesses124112633che_sses
cresses94219813cre_sses
cuisses9319883_cuisses
disses75225963__disses
dresses83716173dre_sses
ecesises1037023ecesises
egresses949443egre_sses
enisles72312603en_isles
enosises8311003enosises
esses56422973__e_sses
fesses94820253_fe_sses
finesses111912343fine_sses
gasses75724783g__asses
gausses8308693g_ausses
gaynesses1336563gayne_sses
geishas1135083g_eishas
geneses82613523g_eneses
genies75324943geni__es
genoises939253genoises
genuses83510883g_enuses
gessoes838293g_essoes
gestes75721393g_e_stes
glasses84414273g_lasses
glosses84014123g_losses
gnashes11419573gn_ashes
gneissoid1151343gneissoid
gnoses76515163gn__oses
gonenesses11310253gonenesses
grasses84117343g_rasses
greases84816713gre_ases
greiges937733grei_ges
greisen856503grei_sen
greisens954653greisens
grilses8319153g_rilses
grosses84517683g_rosses
guessed9176603gue_ssed
guesser8166543gue_sser
guessers9174903gue_ssers
guises74216313g_ui_ses
hisses94719353__hisses
incises93414893inci_ses
jesses135215953_je_sses
kisses104217333__kisses
kneesies1245543kneesies
knesset11310413kne_sset
knessets1243173kne_ssets
knishes1438263kn_ishes
kumisses1443583kumisses
loesses7310033loe_sses
meioses9310833_meioses
messes84924343_me_sses
metisses1036833metisses
misses85130873__misses
neguses837933_neguses
nemeses948663_nemeses
newsies101310383_newsies
nexuses1436743_nexuses
noesises838503noesises
noises65021853_noi_ses
ogresses938473ogre_sses
onenesses9311823onenesses
oyesses1037333oye_sses
pavisses13397103pavisses
peises84125043_pei_ses
pelisses1048483pelisses
penises9318193peni_ses
pisses84525083__pisses
plisses94411773_plisses
premisses13288763premisses
presses93523153pre_sses
prisses94816713_prisses
reissues845993_reissues
seises64026713_sei_ses
sisses64520603__sisses
sneeshes1136513sneeshes
speises93813933spei_ses
swisses10417143_swisses
synesises1245613synesises
teniases838623teniases
tresses73719543tre_sses
uneases73316263une_ases
unkissed1334893unkissed
unwishes14147483unwishes
wisses94619603__wisses
yesses93615813_ye_sses

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.406440125.6
2DLD Change Limit1461621016.93621073.0
3Display Results1011010.0502020.0
 (SQL Overall)1786911017.39224173.6
 
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.