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

97 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
bausond104449(None) 
abscond1244503abscond
abused95614273abus_ed
abusing1049113abusing
almond91410433_almond
arson55118833_arson_
arsons63917213_arsons
augend837633_augend
autoed7712823_autoed
baboon103613913baboon_
baboons113211083baboons
bacon95620593ba_con_
bacons104917583ba_cons
badland1147653badland
balcony1435853balcony
ballon84117493ballon_
ballons93916963ballons
band76740913ba___nd
baron78131243ba_ron_
barong96015823ba_rong
barons85025383ba_rons
barony115915303ba_rony
bartend1038753bartend
baryon111211613baryon_
baryons121010473baryons
based85331583ba_s_ed
bashed126225703ba_shed
basin75026923ba_sin_
basined10310003ba_sined
basing95427663ba_sing
basins85722763ba_sins
basion84315853basion_
basions94213953basions
basked135218603ba_sked
basso76017283basso__
bassoon937613bassoon
bassoons1036553bassoons
bassos85313703basso_s
basswood1494553basswood
basted95227233ba_sted
baton75822423ba_ton_
batons85519423ba_tons
baud74928423bau___d
baudrons1135763baudrons
baulked14465623baulked
bawsunt1244723bawsunt
baywood1646443baywood
beyond1237073b_eyond
bison75716983b_ison_
bisons83914373b_isons
blond85618373b__lond
blouson974893blouson_
blousons1054403blousons
blushed134411753blushed
bolson8410683bolson_
bolsons969483bolsons
bond75334363b___ond
boson76019733b_oson_
bosons85016653b_osons
bound84819583bou__nd
boused95322883bous_ed
bousing103718043bousing
bouton8311533bouton_
boutons9310783boutons
brushed133811213brushed
buboed113010003b_uboed
bund75530663b_u__nd
bused85624493b_us_ed
bushed124822383b_ushed
busied95117223b_usied
busing96420593b_using
busked134917703b_usked
busload1044683b_usload
bussed94717053b_ussed
busted95123153b_usted
caused95117043caus_ed
causing103614413causing
damson938063damson_
damsons1038013damsons
dapsone1038463dapsone
hausen9610383hausen_
hausens1077633hausens
lassoed8408743lassoed
mason74820183ma_son_
masoned1039803ma_soned
masons83916513ma_sons
maund85515453mau__nd
parson83817903parson_
parsons93516873parsons
paused95114963paus_ed
pausing103912813pausing
ramson8310463ramson_
ramsons939563ramsons
tauon54816583tau_on_
tauons63412673tau_ons
yaupon11345493yaupon_
yaupons12345683yaupons

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 Filter1786911340270.403443402.0
2DLD Change Limit134027976.86019537.5
3Display Results97970.0501940.0
 (SQL Overall)178691977.31324434.7
 
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.