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

112 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
bekisses143424(None) 
bekissed1543161bekissed
bekiss1236372beki_s_s
betises94816122beti_ses
blisses94911512b_lisses
brisses94314312b_risses
kisses104217332__kisses
metisses1036832metisses
pelisses1048482pelisses
aegises8311373aegi_ses
badasses1136173badasses
bagasses1136313bagasses
banishes131812463banishes
basses85428303b__asses
batistes1039713batistes
becurses1236723becurses
bedsides1246533bedsides
beiges91014403be_i_ges
beignes10149243be_ignes
bekissing1643503bekissing
belies84631053beli__es
believes13449403believes
bemires113212833bemi_res
bemisted1368383bemisted
bemists113410703bemi_sts
bemixes18338653bemi_xes
bemuses1139293be_muses
benisons1037043benisons
berimes115216643beri_mes
beses75830723be___ses
besides104814533besi_des
besieges1146003besieges
betides104915263beti_des
betimes115114413beti_mes
betise85616273beti_se_
bevies114017303bevi__es
beziques2843213beziques
biases84618433b__iases
biasses94911653b_iasses
bikies124515163biki__es
birses84717733b__irses
bises75435623b__i_ses
blemishes1665083blemishes
blesses93812393b_lesses
blissed10388373b_lissed
bosses85925403b__osses
braises93818873brai_ses
brasses93818353b_rasses
brewises1337213brewi_ses
brises84927613b_ri_ses
bruises93212913brui_ses
busses85023383b__usses
bypasses1533833bypasses
cerises94722253ceri_ses
cesses84221363ce__sses
cuisses9319883_cuisses
degasses10278363degasses
dehisces1464713dehisces
demises103719563demi_ses
devisees12358283devisees
devises114116763devi_ses
disses75225963__disses
egises7312493_egi_ses
enisles72312603_enisles
esses56422973_e__sses
eyasses10388023_eyasses
fesses94820253fe__sses
fetishes1437153fetishes
geniuses935933geniuses
gneisses933673gneisses
hisses94719353__hisses
jesses135215953je__sses
kissed114412853__kissed
kisser104212453__kisser
kissers114211293__kissers
kumisses1443583kumisses
lewises1039133lewi_ses
megasses11307743megasses
meioses9310833me_ioses
merises93421423meri_ses
messes84924343me__sses
metisse936503metisse_
misses85130873__misses
nesses64718323ne__sses
obelises1039103obeli_ses
outkisses1344303outkisses
pavisses13397103pavisses
peises84125043pe_i_ses
pelisse967063pelisse_
penises9318193peni_ses
perishes13313753perishes
pisses84525083__pisses
plisses94411773_plisses
premisses13288763premisses
prisses94816713_prisses
recesses10312323recesses
reissues845993re_issues
relishes11311953relishes
remises93423483remi_ses
repasses101810373repasses
rerises73525883reri_ses
revises104220533revi_ses
seises64026713se_i_ses
semioses10611013semioses
semises93916553semi_ses
sisses64520603__sisses
speisses10245693speisses
swisses10417143_swisses
teniases838623teniases
unkissed1334893unkissed
wisses94619603__wisses
yesses93615813ye__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.1561145455.1
2DLD Change Limit1461621127.39019778.3
3Display Results1121120.0333393.9
 (SQL Overall)1786911127.57923577.1
 
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.