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

132 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
baalisms123803(None) 
baalism11310591baalism_
baalim1038472baali_m_
baptisms1446032baptisms
cabalisms1548432cabalisms
dualisms1147212dualisms
fatalisms1439112fatalisms
kabalisms1745952kabalisms
nasalisms1147172nasalisms
oralisms10610972oralisms
realisms102212162realisms
aaliis6312903_aali_is
abatises10311013abatises
ableisms1245413ableisms
ageisms1056603_ageisms
agisms9399393__agisms
alliums957973_alliums
atavisms1346993atavisms
autisms94311553_autisms
baals76122703baal___s
baases85218013baa__ses
backlists17117413backlists
bailies94120203baili_es
bailiffs1642563bailiffs
balases93815433b_alases
ballasts1037933ballasts
ballies93725743balli_es
ballista1045803ballista
balms95723923b_al__ms
balsams11579013b_alsams
balsas86417523b_al_sas
banalizes201210093banalizes
baptises1238923baptises
baptism1337803baptism_
baptists1236723baptists
barbarisms1644943barbarisms
bariums1139143b_ariums
barless94317003barles_s
basilisks1543103basilisks
bassists1037183bassists
bialies93618413biali_es
bialis83617163biali__s
biblists1236873biblists
binarisms1346413binarisms
bliss75616913b__lis_s
bogyisms1643823bogyisms
bossisms1244703bossisms
botulisms1345303botulisms
boyarisms1645443boyarisms
braises93818873bra_ises
braless92910563brales_s
bromisms1436403bromisms
brutisms1245413brutisms
bruxisms1942943bruxisms
bubalises1346323bubalises
cabalism14310143cabalism_
cabalists1339153cabalists
cabbalisms1844523cabbalisms
cambisms1645803cambisms
canalises11515493canalises
charisms15710263charisms
cladisms1336093cladisms
czarisms2155753czarisms
dadaisms1245123dadaisms
dialists9411413dialists
dualism1049163dualism_
dualists958243dualists
etatisms1038293etatisms
faddisms15264983faddisms
familisms1645863familisms
faradisms15256673faradisms
fascisms1545663fascisms
fatalism13310483fatalism_
fatalists12310023fatalists
fauvisms1643743fauvisms
favisms1535443_favisms
finalisms14318833finalisms
galliums1145963galliums
holisms123811113_holisms
idealisms1246443idealisms
idolisms1146353idolisms
imagisms1344903imagisms
kabalism1647043kabalism_
kabalists1546293kabalists
kabbalisms2042983kabbalisms
kaliums1336603_kaliums
laicisms1247123laicisms
legalisms1247163legalisms
localisms13148733localisms
loyalisms14156623loyalisms
malaises10312333malaises
moralisms13410293moralisms
nanisms938833_nanisms
narcisms1267263narcisms
nasalises948113nasalises
nasalism1048203nasalism_
obeahisms1642853obeahisms
obelisms1236393obelisms
odalisks1363503odalisks
onanisms1048063onanisms
oralism9513763oralism_
oralists8611803oralists
oxalises1538503oxalises
paeanisms1347583paeanisms
paganisms1447933paganisms
palliums1236703palliums
papisms13238543_papisms
phallisms1645073phallisms
pianisms1249013pianisms
ptyalisms1685303ptyalisms
racialisms1447223racialisms
racisms112310813_racisms
realises82420183realises
realism93115923realism_
realists83014843realists
royalisms14127263royalisms
ruralisms1147353ruralisms
sadisms10359113_sadisms
satanisms1148143satanisms
savagisms1544063savagisms
statisms1039543statisms
tachisms1567143tachisms
tallises82713263tallises
totalisms1139813totalisms
tsarisms1056653tsarisms
tzarisms1965213tzarisms
uranisms1099973uranisms
valises103516263_valises
vandalisms1645803vandalisms
vitalisms1448513vitalisms
vocalisms16138053vocalisms
wholisms1665253wholisms

Search took 9 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.420425454.8
2DLD Change Limit1461621328.03318195.2
3Display Results1321320.0632095.2
 (SQL Overall)1786911328.51620983.0
 
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.