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

112 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
waggliest143478(None) 
wiggliest1444881wiggliest
baggiest123011752bagg_iest
dangliest1137172dangliest
faggiest132910182fagg_iest
gangliest1137672gangliest
giggliest1234322giggliest
goggliest1234062goggliest
jaggiest17289322jagg_iest
jangliest1746382jangliest
jiggliest1854182jiggliest
naggiest102610012nagg_iest
niggliest1144932niggliest
saggiest102812722sagg_iest
tangliest1068422tangliest
wabbliest16274962wabbliest
waffliest1844232waffliest
waggles123812002waggl_es_
wagglier1344322wagglie_r
wambliest16255152wambliest
wiggiest13269012wigg_iest
wriggliest1542932wriggliest
aggies83515513_agg_ies_
angriest9310253_angriest
baggies113814853bagg_ies_
boggiest123110933bogg_iest
braggiest13116783bragg_iest
buggiest123410363bugg_iest
cagiest102916433ca_g_iest
craggiest13116523cragg_iest
daggles103611913daggl_es_
darkliest1435163darkliest
doggiest113410523dogg_iest
draggiest12126413dragg_iest
earliest82415243ea_rliest
flaggiest14145513flagg_iest
foggiest13249653fogg_iest
fuggiest13228813fugg_iest
gaggles103512593gaggl_es_
gainliest1037133gainliest
hackliest1836523hackliest
haggles123312483haggl_es_
jaggedest1942853jaggedest
jaggies163311083jagg_ies_
jiggiest17277693jigg_iest
jingliest1735973jingliest
jungliest1744923jungliest
kingliest1436523kingliest
leggiest10308233legg_iest
loggiest103011013logg_iest
mangiest112815903mang_iest
manliest102314943ma_nliest
marbliest1336763marbliest
marliest102415183ma_rliest
muggiest12228533mugg_iest
paliest93021613pa__liest
palliest102814643pa_lliest
piggiest12259663pigg_iest
puggiest12219223pugg_iest
quaggiest2044173quagg_iest
raggedest1244013raggedest
raggediest1343423raggediest
raggies93214733ragg_ies_
raggles93813283raggl_es_
rangiest93115983rang_iest
sagiest82617993sa_g_iest
scraggliest1542483scraggliest
shaggiest14156903shagg_iest
slaggiest11157713slagg_iest
snaggiest11126683snagg_iest
soggiest102711643sogg_iest
spangliest1345163spangliest
staggiest11148263stagg_iest
straggliest1343613straggliest
swaggies13136693swagg_ies_
tangiest92915223tang_iest
tingliest1047683tingliest
twangiest1355223twang_iest
twiggiest1443413twigg_iest
ugliest8410153__ugliest
vuggiest13216923vugg_iest
wackiest172610273wa_ckiest
wageless1237173wagel_ess
waggeries14127463waggeries_
waggish15207073wagg_i_sh
waggle113612303waggl_e__
waggled13389363waggl_e_d
waggling14197063waggli_ng
waitlist1147743waitli_st
walies95324523wa__lies_
wallies103320743wa_llies_
wangles113416933wangl_es_
waniest103819113wa__niest
wariest105122503wa__riest
wartiest113614643wa_rtiest
washiest14310413wa_shiest
waspiest1338823wa_spiest
wateriest12312233wateriest
waviest134513073wa__viest
waxiest173510883wa__xiest
weakliest1635853weakliest
wedgiest13307983wedg_iest
whirliest15216043whirliest
wifeliest1545883wifeliest
wiggles123312463wiggl_es_
wigglier1354453wigglie_r
wiliest103416593w__iliest
wingiest123214283wing_iest
wiseliest1237723wiseliest
wobbliest16275333wobbliest
wooliest113011643w_ooliest
woolliest1235853woolliest

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 Filter1786911486410.440406115.9
2DLD Change Limit1486411126.79621871.8
3Display Results1121120.0462434.8
 (SQL Overall)1786911127.28224538.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.