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

148 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
bassists103718(None) 
assists738471_assists
bassist9312741bassist_
assist6314602_assist_
baptists1236722baptists
bassets96414822bass_ets
bassetts10407372bassetts
bassinets1146322bassinets
bossisms1244702bossisms
cassises103811742cassises
casuists1036522casuists
classists11296242classists
coassists11275762coassists
fascists1336612fascists
ableists1036543ableists
abscises1246233abscises
ageists848493_ageists
agists75713173_a_gists
aorists74215833_aorists
artists74215593_artists
aspises9611643_aspises
assents74512223_assents
asserts74311793_asserts
assess65710463_asses_s
assets65617663_ass_ets
assigns836193_assigns
assisted936233_assisted
assister836753_assister
assisters936353_assisters
assistor844823_assistor
assistors945253_assistors
assizes1638453_assizes
assorts73310153_assorts
aurists74615783_aurists
autists73814853_autists
baalisms1238033baalisms
babbitts1144023babbitts
babysits15143543babysi_ts
backlists17117413backlists
baits76630583ba__i_ts
ballasts1037933ballasts
ballista1045803ballista
bandits103814793bandi_ts
banjoists1843253banjoists
bankits133410153banki_ts
baptises1238923baptises
baptisms1446033baptisms
baptist11311873baptist_
barista9310813ba_rista
baristas1039723ba_ristas
basalts9358963ba_salts
basest84720493ba_sest_
bashings144311243bashings
basics104915123ba_si_cs
basilisks1543103basilisks
basils85717473ba_si_ls
basinets1039063basinets
basins85722763ba_si_ns
basions94213953ba_sions
basis75429863ba_si__s
baskets135111833ba_skets
basses85428303ba_s_ses
basset85225383bass_et_
bassett94213863bass_ett
bassi77019323bassi___
bassinet10312843bassinet
bassness1096743bassness
bassoonists1352293bassoonists
bassoons1036553bassoons
bassos85313703ba_s_sos
bastiles10313353bastiles
bastings114214693bastings
bastions10411693bastions
basts75936933ba___sts
batiste939743ba_tiste
batistes1039713ba_tistes
bedsits1037563bedsi_ts
bemists113410703b_emists
biblists1236873biblists
bossies94116833bossi_es
bossiest103112213bossiest_
bossism1136063bossis_m
brassarts1143823brassarts
brassicas1344053brassicas
brassies103613533brassi_es
brassiest11369713brassiest_
brassish1346433brassis_h
bundists1145383bundists
bussings11386663bussings
byssuses1342273byssuses
cambists1437023cambists
cassias93514343cassi_as
cassinas103610643cassinas
cassines103116613cassines
cassinos10309353cassinos
cassis84818853cassi__s
casuist9411303casuist_
classisms13295523classisms
classist104010383classist_
coassist10298803coassist_
consists10310593consists
cosmists1237993cosmists
dadaists1045583dadaists
dassies84418663dassi_es
desists83611723_desists
faddists13235543faddists
fascisms1545663fascisms
fascist1239213fascist_
fauvists1443843fauvists
gassiest93212523gassiest_
gassings10438403gassings
harpists1338103harpists
hassiums1344273hassiums
insists739083_insists
jassids1586143jassi_ds
lassies74420103lassi_es
lassis65216703lassi__s
maists85817573ma__ists
massicots1343843massicots
massiest103314423massiest_
massifs1237743massi_fs
missises103513693missises
narcists1078113narcists
palmists12268813palmists
papists112110453pa_pists
passings11409873passings
passions10310583passions
passives13228823passives
passivists1544003passivists
passuses1036773passuses
pastises103616053pastises
persists1049183persists
racists92613323ra_cists
rapists92510753ra_pists
resists74414923_resists
sacrists1039563sacrists
sadists83310853sa_dists
sassies74719263sassi_es
sassiest83413623sassiest_
shists96515113__shists
subsists1037993subsists
tachists1348183tachists
tanists7313653ta_nists
tassets75012773tass_ets
tassies74918933tassi_es
tsarists857303tsarists
tussises835433tussises
waists97415453wa__ists

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 Limit1461621487.53319402.9
3Display Results1481480.0602466.7
 (SQL Overall)1786911488.01322300.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.