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

95 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
blouson97489(None) 
blousons1054401blousons
blossom11114962blossom
blouse84714722blous_e
bloused104310642bloused
blouses94014462blouses
blousing1138792blousing
blousy11459122blous_y
bolson8410682b_olson
boson76019732b_o_son
bouton8311532b_outon
aleuron757383aleuron
allusion846573allusion
bausond1044493b_ausond
benison937123benison
biotron937293biotron
bison75716983b__ison
blaubok1542243blaubok
blazon1736763bl_azon
blobs95620033blobs__
blocs95219653blocs__
blogs85319233blogs__
blood85319523blo__od
bloom95918973blo__om
bloop96116153blo__op
blossoms12134553blossoms
blossomy15113203blossomy
blots75626173blots__
blotto8198443blotto_
blousier1055663blousier
blousily1345193blousily
blowdown1743243blowdown
blowgun1342653blowgun
blowjob2141753blowjob
blown105716673blo__wn
blows105423833blows__
blowsed13449023blowsed
blowsy14579453blows_y
blush105115313bl_us_h
bolsons969483b_olsons
bolus79125543bolus__
boluses94113833boluses
bonbon10310073b_onbon
boon67142173b_o__on
boron76727143b_o_ron
bosom95516923b_o_som
bosons85016653b_o_sons
boston8513043b_oston
bosun75113593b_o_sun
boubou1038433b_oubou
boudin9412373b_oudin
bourbon1135813b_ourbon
bourdon1036423b_ourdon
bourn75518483b_ou_rn
boursin938283b_oursin
bouse75931853b_ous_e
boused95322883b_oused
bouses84931783b_ouses
bousing103718043b_ousing
bousy104917843b_ous_y
boutons9310783b_outons
classon937693classon
coupon102810993_coupon
cousin8517163_cousin
crouton947133crouton
dobson936593_dobson
elusion72310953el_usion
fleuron1055573fleuron
foison948933_foison
gluon6311223gl_u_on
godson857383_godson
illusion846573illusion
lesson64412043_lesson
leukon1036143_leukon
logion76013723_logion
logon615922313_lo_gon
loon47344793_lo__on
loosen66615963_loosen
lotion65716523_lotion
louden73711793_louden
loupen84510293_loupen
louse56131013_lous_e
loused74822913_loused
louses66230283_louses
lousing83817733_lousing
lousy84617083_lous_y
mouton8410853_mouton
pleuron976343pleuron
pleuston1044193pleuston
plosion939113plosion
pluton838853pl_uton
poison8312223_poison
sponson935383sponson
voudon1035873_voudon
youpon11366003_youpon

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.420425454.8
2DLD Change Limit134027956.87619492.0
3Display Results95950.0303166.7
 (SQL Overall)178691957.32624391.3
 
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.