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 “quaggier” 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
quaggier193385(None) 
baggier113611642_baggier
braggier12136452braggier
buggier113611342bu_ggier
craggier12116062craggier
draggier11135772draggier
faggier12309842_faggier
flaggier13105202flaggier
fuggier12348962fu_ggier
jaggier16339182_jaggier
muggier11288942mu_ggier
naggier9309152_naggier
puggier11309382pu_ggier
quackier23215372quackier
quaggiest2044172quaggiest
quagmire2042382quagmire
quakier20239202qua_kier
qualmier1934562qualmier
quarrier1736842quarrier
quartier1737542quartier
saggier92912062_saggier
shaggier13116052shaggier
slaggier10126952slaggier
snaggier10136302snaggier
staggier10167512staggier
vuggier12296812vu_ggier
agger76420893__agg_er
aggie73415013__aggie_
aggies83515513__aggies
bagger104619203_bagg_er
baggie102912193_baggie_
baggies113814853_baggies
boggier113711583_boggier
bragger113810043bragg_er
bugger104418723bu_gg_er
buggies114613813bu_ggies
bulgier103911213bu_lgier
cagier93715933_ca_gier
cloggier1244253cloggier
dagger95017303_dagg_er
doggier103810943_doggier
dragger10309173dragg_er
dreggier1193553dreggier
druggier11134833druggier
dungier9368583du_ngier
flagger12469353flagg_er
foggier12349913_foggier
froggier1354643froggier
gagger95016513_gagg_er
groggier1134343groggier
haggler12328933_haggler
hugger114713123hu_gg_er
hungrier1233893hungrier
jagger154016003_jagg_er
jaggies163311083_jaggies
jiggier16377823_jiggier
juggler16418873ju_ggler
junglier1644303junglier
lagger85919833_lagg_er
leggier9368233_leggier
loggier93811143_loggier
lugger83916553lu_gg_er
luggie8318903lu_ggie_
luggies93011213lu_ggies
mangier104114063_mangier
mugger103914703mu_gg_er
nagger84016123_nagg_er
orangier947713orangier
piggier113510003_piggier
pudgier11377723pu_dgier
quaffer2235133qua_ffer
quagga1754143quagg__a
quaggas1893703quagg_as
quaggy2084683quagg__y
quagmires2142303quagmires
quagmirier2251273quagmirier
quagmiry2341723quagmiry
quainter1765903quainter
quaker193811623qua__ker
qualifier2145123qualifier
quantizer2743973quantizer
quarried1836093quarried
quarriers1845183quarriers
quarries1749943quarries
quarter163211853qua_rter
quartiers1845183quartiers
quasher19198623qua_sher
quaver18309313qua__ver
quaverer2054583quaverer
queasier1734473queasier
queazier2642833queazier
querier16310013qu_erier
quippier2133773quippier
quirkier2134163quirkier
raggies93214733_raggies
rangier83714353_rangier
rugger84414513ru_gg_er
sagger84321073_sagg_er
sagier73717163_sa_gier
scraggier1344133scraggier
slangier9117933slangier
smoggier1243973smoggier
soggier93410883_soggier
squabbier2242753squabbier
squallier1844363squallier
squashier2143913squashier
squattier1843713squattier
squigglier2141593squigglier
stagger94212393stagg_er
staggie9138463staggie_
staggies101210323staggies
stagier83513443sta_gier
sugarier937393sugarier
swagger12389333swagg_er
swaggie12135783swaggie_
swaggies13136693swaggies
tagger84017703_tagg_er
tangier83013903_tangier
tugger84013103tu_gg_er
twangier1254243twangier
twiggier1333073twiggier
uglier748953_u_glier
wagger113616013_wagg_er
wagglier1344323_wagglier
wiggier12418863_wiggier

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 Filter1786911461620.720248181.9
2DLD Change Limit1461621257.00020880.3
3Display Results1251250.0462717.4
 (SQL Overall)1786911257.76623009.4
 
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.