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 “bloats” with Change Limit: [1] [2] [3]

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
bloats8521576(None) 
blats75132501bl_ats
bleats85518611bleats
bloat75229921bloat_
blots75626171blo_ts
boats75635151b_oats
floats96816251floats
gloats74515421gloats
bats66962332b__ats
beats76042242b_eats
bhoots11459912bhoots
bionts8612392bionts
biotas84313922biotas
blabs95619632bl_abs
blahs105616512bl_ahs
blams95023852bl_ams
blast76532572bl_ast
blasts85116772blasts
blat66550952bl_at_
blate75933782bl_ate
blaws105620462bl_aws
bleaks125112432bleaks
blears85116452blears
bleat75737002bleat_
blets75324942bl_ets
bloated104513432bloated
bloater94013422bloater
bloaters103311022bloaters
blobs95620032blo_bs
blocks144513942blocks
blocs95219652blo_cs
blogs85319232blo_gs
blokes123813882blokes
blonds95213342blonds
bloods94614842bloods
blooms104613172blooms
bloops106611342bloops
blot65842322blo_t_
blotto8198442blotto
blotty11178342blotty
blows105423832blo_ws
bluets87215492bluets
blunts84512892blunts
blurts84412642blurts
boars75229602b_oars
boarts84716872b_oarts
boas66150832b_oa_s
boast75935702b_oast
boasts85017922b_oasts
boat66360312b_oat_
bolas74733762bola_s
bolts76232112b_olts
boosts86115012boosts
boots75837972b_oots
borts76735452b_orts
botas75328782b_otas
bots66453952b_o_ts
botts75224862b_otts
bouts75131312b_outs
brats75336012b_rats
broads94515152broads
cleats84919312cleats
cloaks124411262cloaks
cloots85113692cloots
clots75627642clo_ts
clouts87017202clouts
coats75635002_coats
doats65224882_doats
flats86429742fl_ats
float85928572float_
floaty124210942floaty
flotas94013002flotas
flouts94315272flouts
gloams95210662gloams
gloat65427682gloat_
glosts74513812glosts
glouts74414712glouts
goats65527302_goats
groats74816652groats
lats45962702_l_ats
loads65323372_loads
loafs85616992_loafs
loams75619862_loams
loans56026462_loans
loath84918602_loath
lofts85518362_lofts
loots55431422_loots
lotas55926302_lotas
lots47652092_lo_ts
louts56330272_louts
lovats939072_lovats
moats75827642_moats
oats46554212__oats
plats75531372pl_ats
pleats85218592pleats
plots75025672plo_ts
shoats94117082shoats
slats55436902sl_ats
slots54830532slo_ts
stoats65117482stoats

Search took 3 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 Filter178691825510.343520965.0
2DLD Change Limit825511002.42334069.7
3Display Results1001000.0166250.0
 (SQL Overall)1786911002.78264231.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.