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

126 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
quagga175414(None) 
quaggas1893701quaggas
quaggy2084681quaggy
dagga839542_dagga
quag144815942qua_g_
quags154613252qua_gs
quaigh1935462quaigh
qualia1559562qualia
quango1636492quango
quanta153911332quanta
aga410447233__a_ga
agha87417303__agha
agma77623263__agma
alga57927603__alga
anga56831353__anga
aquaria1638043aquaria
baggy125615683_baggy
braggy13337173braggy
buggy124613483bu_ggy
craggy13396603craggy
daggas937973_daggas
draggy12346823draggy
faggy136514373_faggy
fanga96119623_fanga
flaggy14415923flaggy
fuggy135411673fu_ggy
gaga66625553_ga_ga
guava938583gua_va
jagg136115313_jagg_
jaggs148111493_jaggs
jaggy175913143_jaggy
jagra1338173_jagra
juga126417323ju__ga
magma104513573_magma
manga85026203_manga
mugg86316013mu_gg_
muggar10316443mu_ggar
muggs94912323mu_ggs
muggy125612373mu_ggy
naggy106612823_naggy
oquassa1642063oquassa
panga85323533_panga
puggy124612323pu_ggy
qua124821973qu___a
quack203812503qua_ck
quacks214710103quacks
quacky24376963quacky
quad144618703qua__d
quadrat1769273quadrat
quadriga1944073quadriga
quads154515843qua_ds
quaere154110673quaere
quaff201311353qua_ff
quaffs21125693quaffs
quaggier1933853quaggier
quahog1944103quahog
quahogs2043163quahogs
quai134420393qua__i
quaich2047693quaich
quaighs2043493quaighs
quail144314363qua_il
quails153412643quails
quaint15415173quaint
quais144618393qua_is
quake184114643qua_ke
quaked203910033quaked
quaker193811623quaker
quakes194013343quakes
quaky214310743qua_ky
quale143617853qua_le
qualm163511183qua_lm
qualms17317243qualms
qualmy20285803qualmy
quangos1734653quangos
quant143624813qua_nt
quantal16367893quantal
quants153614143quants
quare143920543qua_re
quark184614123qua_rk
quarks193810913quarks
quarry1837473quarry
quart144027853qua_rt
quartan1636423quartan
quarte154115323quarte
quarto153511123quarto
quarts154715933quarts
quartz244212103quartz
quasar1536833quasar
quash174512163qua_sh
quasi144015023qua_si
quass144413763qua_ss
quassia1644793quassia
quate144521413qua_te
quatre153512353quatre
quaver18309313quaver
quay164618353qua__y
quayage2044573quayage
quays174612043qua_ys
quelea1547303quelea
quinoa15377653quinoa
quinta153312373quinta
quokka1841893quokka
quota145111963qu_ota
quotha18365113quotha
raga55930813_ra_ga
ragg65622693_ragg_
raggs75216473_raggs
raggy106116573_raggy
ruana5312423rua_na
ruga56121233ru__ga
saga55331173_sa_ga
saggar84010853_saggar
saggy105917463_saggy
saiga64717933_saiga
sanga66023793_sanga
shaggy14478043shaggy
slaggy11438793slaggy
snaggy11488053snaggy
squama1736533squa_ma
staggy115510393staggy
taiga64115663_taiga
tanga64923693_tanga
vugg95612713vu_gg_
vuggs10579133vu_ggs
vuggy13589483vu_ggy
yuga85615423yu__ga

Search took 5 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 Filter1786911127160.1261418182.5
2DLD Change Limit1127161264.65324224.4
3Display Results1261260.0333818.2
 (SQL Overall)1786911264.81237134.5
 
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.