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

100 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
bassinets114632(None) 
basinets1039061ba_sinets
bassinet10312841bassinet_
basinet9318932ba_sinet_
bassets96414822bass__ets
bassists1037182bassi_sts
bassness1096742bass_ness
bossiness11257422bossiness
brassiness1235482brassiness
cassines103116612cassine_s
gassiness10268312gassiness
massiness112810142massiness
sassiness8249332sassiness
arsines73518813_arsine_s
ashiness1138963_ashiness
assents74512223_assen_ts
assets65617663_ass__ets
assignats1044003_assignats
assignees1043503_assignees
assigners1044413_assigners
assists738473_assi_sts
assizes1638453_assize_s
bagginess1355953bagginess
balkiness1556903balkiness
ballonets1146723ballonets
balminess1356593balminess
bandiness122310243bandiness
bannets94013843ba__nnets
baronets101410903ba_ronets
baseliners1243863baseliners
baselines1138603baseline_s
basements1348263basements
baseness10910943ba_seness
bashings144311243bashin_gs
basilects1342973ba_silects
basined10310003ba_sine_d
basins85722763ba_sin__s
baskets135111833ba_s_kets
basses85428303bass__e_s
basset85225383bass__et_
bassett94213863bass__ett
bassetts10407373bass_etts
bassist9312743bassi_st_
bastiles10313353bastile_s
bastings114214693bastin_gs
battiness11239843battiness
bawdiness15235543bawdiness
bayonets13135583ba_yonets
bobbinets1243073bobbinets
boskiness15196513boskiness
bossies94116833bossi_e_s
bossiest103112213bossi_est
brassies103613533brassi_e_s
brassiest11369713brassi_est
bushiness14177763bushiness
business102110693b_usiness
bussings11386663bussin_gs
bustiness111810473bustiness
cabinets1238283ca_binets
cassenes103611293cassene_s
cassinas103610633cassin_as
cassine93817283cassine__
cassinos10309353cassin_os
cassises103811743cassise_s
castanets1146333castanets
classiness12196313classiness
dassies84418663dassi_e_s
easiness8313043ea_siness
fascines13310143fascine_s
fussiness12226583fussiness
gassiest93212523gassi_est
gassings10438403gassin_gs
glassines10278043glassine_s
glassiness11245993glassiness
hastiness122410883hastiness
jasmines1736623jasmine_s
lassies74420103lassi_e_s
martinets1138883martinets
massicots1343843massicots
massiest103314423massi_est
messiness11248223messiness
mossiness11258323mossiness
mussiness11238303mussiness
nastiness92310573nastiness
passings11409873passin_gs
passives13228823passive_s
pastiness112312353pastiness
raspiness1137303raspiness
sarsenets946513sarsenets
sarsnets836783sars_nets
sassies74719263sassi_e_s
sassiest83413613sassi_est
satinets8311733sa_tinets
sissiness8217963sissiness
spinets94714813__spinets
tassets75012773tass__ets
tassies74918933tassi_e_s
tastiness92311143tastiness
washiness1537043washiness
waspiness1435793waspiness

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.420425454.8
2DLD Change Limit1486411007.45319943.8
3Display Results1001000.0462173.9
 (SQL Overall)1786911007.91922564.8
 
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.