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

115 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
bassinet1031284(None) 
basinet9318931ba_sinet
bassinets1146321bassinets
basined10310002ba_sined
basinets1039062ba_sinets
basset85225382bass__et
bassist9312742bassi_st
cassine93817282cassine_
cassines103116612cassines
abstinent1145923abstinent
arsine64021053_arsine_
arsines73518843_arsines
assent65119953_assen_t
asset55932263_ass__et
assignat945683_assignat
assigned1044633_assigned
assignee944843_assignee
assigner944853_assigner
assist6314603_assi_st
assize1538633_assize_
assizes1638453_assizes
ballonet10314503ballonet
bannet84925333ba__nnet
baronet91022213ba_ronet
baseline10310753baseline_
baseliner1144753baseliner
baselines1138603baselines
basement12311493basement
bashing135422583bashin_g
bashings144311243bashings
basilect1245903ba_silect
basin75026923ba_sin__
basinal9310033ba_sinal
basing95427663ba_sin_g
basins85722763ba_sin_s
basket125722913ba_s_ket
basking144718613baskin_g
basses85428303bass__es
basseted1136753basseted
bassets96414823bass__ets
bassett94213863bass_ett
bassi77019323bassi___
bassists1037183bassists
bassness1096743bass_ness
bastile9313913bastile_
bastiles10313353bastiles
basting104227203bastin_g
bastings114214693bastings
bastioned1246863bastioned
bawsunt1244723bawsun_t
bayonet121212213ba_yonet
biassing11307263biassin_g
bobbinet1157903bobbinet
bossier93712423bossi_er
bossies94116833bossi_es
bossiest103112213bossiest
bossiness11257423bossiness
bossing103714603bossin_g
brassie93411523brassi_e_
brassier103310533brassi_er
brassies103613533brassi_es
brassiest11369713brassiest
brassiness1235493brassiness
brassing112612303brassin_g
buskined1534443buskined
bussing103614623bussin_g
bussings11386663bussings
cabinet11318903ca_binet
cassene93111543cassene_
cassenes103611293cassenes
cassina94113163cassin_a
cassinas103610643cassinas
cassino93512433cassin_o
cassinos10309353cassinos
cassises103811743cassises
castanet10416193castanet
dassie74615573dassi_e_
dassies84418663dassi_es
fascine12510583fascine_
fascines13310143fascines
gassier83812573gassi_er
gassiest93212523gassiest
gassiness10268323gassiness
gassing94216333gassin_g
gassings10438403gassings
glassine9329313glassine_
glassines10278043glassines
jasmine1636643jasmine_
jasmines1736623jasmines
lassie64917743lassi_e_
lassies74420103lassi_es
martinet10319663martinet
massicot1246583massicot
massier93615223massi_er
massiest103314423massiest
massiness112810143massiness
massing104318023massin_g
massive12289773massive_
passant9813943passan_t
passing104318423passin_g
passings11409873passings
passive12239593passive_
passives13228823passives
sarsenet8412943sarsenet
sarsnet7314813sars_net
sassier73413233sassi_er
sassies74719263sassi_es
sassiest83413623sassiest
sassiness8249333sassiness
sassing84615553sassin_g
satinet7325283sa_tinet
spinet85629753__spinet
tasset65925313tass__et
tassie66017023tassi_e_
tassies74918933tassi_es

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.580308087.9
2DLD Change Limit1461621158.11018022.4
3Display Results1151150.0462500.0
 (SQL Overall)1786911158.73620454.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.