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

91 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
gloats7451542(None) 
bloats85215761bloats
floats96816251floats
gloams95210661gloams
gloat65427681gloat_
glosts74513811glosts
glouts74414711glouts
goats65527301g_oats
groats74816651groats
blats75132502bl_ats
bleats85518612bleats
bloat75229922bloat_
blots75626172blo_ts
boats75635152_boats
cleats84919312cleats
cloaks124411262cloaks
cloots85113692cloots
clots75627642clo_ts
clouts87017202clouts
coats75635002_coats
doats65224882_doats
flats86429742fl_ats
float85928572float_
floaty124210942floaty
flotas94013002flotas
flouts94315272flouts
galoots82410792galoots
gats56753442g__ats
ghats95818612g_hats
ghosts10489272ghosts
glads75620612gl_ads
glams85822932gl_ams
glans65125832gl_ans
glass65518132gl_ass
gleams94812252gleams
gleans75014742gleans
gleets75315052gleets
glias64618492glia_s
glints75714212glints
gloam86015942gloa_m
gloated93511532gloated
gloater83711012gloater
gloaters9288862gloaters
globate1057822globate
globes94314542globes
globs85616402glo_bs
gloggs935032gloggs
gloms85219782glo_ms
glomus9468092glomus
glooms96211682glooms
glops85619552glo_ps
gloss64319622glo_ss
glost65422932glost_
glottis837172glottis
glout65925812glout_
gloves104115182gloves
glows95518032glo_ws
glozes164313352glozes
gluts66120132gl_uts
gnats65217712g_nats
goads77022852g_oads
goals65521292g_oals
goas55239942g_oa_s
goat56250832g_oat_
gouts64826172g_outs
greats76318392greats
groans74815062groans
groat65531972groat_
grots65025852gro_ts
grouts75015612grouts
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.373479064.3
2DLD Change Limit82551912.17337989.4
3Display Results91910.0303033.3
 (SQL Overall)178691912.57669367.6
 
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.