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

69 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
bekissing164350(None) 
bemisting1438072bemisting
blissing1136872b_lissing
kissing122911052__kissing
banishing1537143banishing
becursing1435453becursing
bedimming1743643bedimming
beeswing14255763be_eswing
befitting15236623befitting
beginning1344613beginning
begirding1434333begirding
bekiss1236373bekiss___
bekissed1543163bekiss_ed
bekisses1434243bekiss_es
believing1535283believing
bemiring13239603bemi_ring
bemixing20226523bemi_xing
bemusing1336613be_musing
beriming13310453beri_ming
besieging1344763besieging
besting104923923be__sting
betiding1239913beti_ding
bewigging1743443bewigging
biasing103512453b__iasing
biassing11307263b_iassing
blemishing1843513blemishing
blessing1137593b_lessing
bossing103714603b__ossing
braising113014563brai_sing
brassing112612303b_rassing
brisking15329473b_risking
brisling112410843b_risling
bruising11279143brui_sing
bussing103614623b__ussing
bypassing1742953bypassing
cessing103814813ce__ssing
degassing1234823degassing
dehiscing1643733dehiscing
delisting112710503delisting
demising122012523demi_sing
desisting112810383desisting
devising133111523devi_sing
dissing94517683__dissing
enisling949633_enisling
existing1639073_existing
fessing113812863fe__ssing
heisting123411043he_isting
hissing114213143__hissing
jessing153710623je__ssing
messing103916393me__ssing
missing103619073__missing
obelising1256323obeli_sing
outkissing1544323outkissing
peising103416763pe_i_sing
perishing1539533perishing
pissing103914803__pissing
prissing113011453_prissing
recessing12611013recessing
reissuing1034613re_issuing
relishing13229183relishing
relisting102414353relisting
remising112516453remi_sing
repassing12249423repassing
rerising93017783reri_sing
resisting103215303resisting
revising122714403revi_sing
seising84018863se_i_sing
wissing113212943__wissing
yessing113210063ye__ssing

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.1561145455.1
2DLD Change Limit148641697.54619698.0
3Display Results69690.0135307.7
 (SQL Overall)178691697.71523161.5
 
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.