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

125 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
flaggiest1414551(None) 
faggiest132910181f_aggiest
slaggiest11157711slaggiest
baggiest123011752_baggiest
braggiest13116782braggiest
cloggiest1334722cloggiest
craggiest13116522craggiest
draggiest12126412draggiest
flabbiest1644212flabbiest
flaggier13105202flaggie_r
flakiest153210552fla_kiest
flamiest133111982fla_miest
flappiest1644862flappiest
flashiest1557992flashiest
flawiest14298582fla_wiest
flaxiest18298192fla_xiest
fledgiest1444182fledgiest
foggiest13249652f_oggiest
froggiest1434912froggiest
fuggiest13228812f_uggiest
jaggiest17289322_jaggiest
leggiest10308232_leggiest
loggiest103011012_loggiest
naggiest102610012_naggiest
quaggiest2044172quaggiest
saggiest102812722_saggiest
shaggiest14156902shaggiest
slangiest10129082slangiest
snaggiest11126682snaggiest
staggiest11148262staggiest
aggies83515513__aggies_
baggies113814853_baggies_
blastiest111710053blastiest
boggiest123110933_boggiest
braggest1296533bragg_est
buggiest123410363_buggiest
cagiest102916433_ca_giest
clammiest1535743clammiest
clankiest1536673clankiest
classiest11309553classiest
clayiest1337923cla_yiest
clingiest1257133clingiest
doggiest113410523_doggiest
dreggiest12124543dreggiest
druggiest12134973druggiest
faddiest1338113f_addiest
faggier12309843f_aggie_r
fanciest133612713f_anciest
fattiest113514313f_attiest
fawniest14287443f_awniest
featliest1238363featliest
flagged13459633flagg_e_d
flagger12469353flagg_e_r
flaggers13328073flagg_ers
flagging14329233flaggi_ng
flaggings15285183flaggings
flagless1235403fla_gless
flanges113413273flang_es_
flattest1138713fla_ttest
flauntiest1343783flauntiest
flautist1186803flauti_st
fleeciest1434873fleeciest
fleshiest1576233fleshiest
fliest94718433fl___iest
flightiest1744513flightiest
flimsiest1434463flimsiest
flintiest1248433flintiest
flirtiest1236193flirtiest
floatiest1237293floatiest
flockiest1835643flockiest
floppiest1654783floppiest
flossiest12296803flossiest
fluffiest1434093fluffiest
flukiest15248063fl_ukiest
flutiest112610883fl_utiest
foamiest13289853foa_miest
fringiest1347603fringiest
gladiest101710343gla_diest
gladliest1135383gladliest
glairiest1035493glairiest
glariest92012533gla_riest
glassiest10279253glassiest
glaziest18227923gla_ziest
groggiest1235093groggiest
jaggies163311083_jaggies_
jiggiest17277693_jiggiest
kludgiest1543153kludgiest
laciest93819043_la_ciest
lakiest113517273_la_kiest
lambiest122410193_lambiest
lankiest122912503_lankiest
lardiest93813893_lardiest
largest83715103_larg_est
larkiest123713323_larkiest
lathiest11312663_lathiest
laziest163814483_la_ziest
ledgiest10288593_ledgiest
lingiest93715263_lingiest
logiest82515543_l_ogiest
luggies93011213_luggies_
mangiest112815903_mangiest
muggiest12228533_muggiest
orangiest1038463orangiest
piggiest12259663_piggiest
plashiest1478383plashiest
platiest103216093pla_tiest
puggiest12219223_puggiest
raggies93214733_raggies_
rangiest93115983_rangiest
sagiest82617993_sa_giest
scraggiest1444373scraggiest
slaggier10126953slaggie_r
slatiest82616273sla_tiest
sludgiest1135813sludgiest
smoggiest1334463smoggiest
soggiest102711643_soggiest
staggies101210323staggies_
stagiest91613413sta_giest
swaggies13136693swaggies_
tangiest92915223_tangiest
twangiest1355223twangiest
twiggiest1443413twiggiest
vuggiest13216923_vuggiest
waggliest1434783_waggliest
wiggiest13269013_wiggiest

Search took 7 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 Filter1786911486410.423422437.4
2DLD Change Limit1486411256.40623203.4
3Display Results1251250.0631984.1
 (SQL Overall)1786911256.89225927.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.