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 “agues” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

172 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
agues6491905(None) 
ages55844591ag_es
ague55725921ague_
argues74516411argues
abbes96723522abbes
ables75935542ables
abuse77119562abuse
abuses85119102abuses
abuts75417072abuts
abyes105518532abyes
aces67645092a_ces
aches106132292aches
acmes96020652acmes
acnes75922622acnes
acres76327762acres
acutes83917722acutes
adzes155913802adzes
aedes64625142aedes
agapes95212412agapes
agars66120642agars
agas55938842ag_as
agates76121332agates
agaves104611512agaves
age47154332ag_e_
aged67334252ag_ed
agee56241492ag_ee
agenes74720252agenes
ager55935842ag_er
agers65027852agers
agger76420892agger
aggers85817792aggers
aggies83515512aggies
aghas97014872aghas
agios65919862agios
aglee65728492aglee
aglet65534142aglet
aglets73915682aglets
agley96917332agley
agmas85919872agmas
agones75719862agones
agons66423782agons
agree65226032agree
agrees74915322agrees
ags47551662ag__s
aguish1059282aguish
aides65336602aides
akees96119242akees
ales47067102a_les
algums9208042algums
almes75126542almes
aloes54933672aloes
alums75720602alums
amies76837692amies
amus65529612amu_s
amuse75920832amuse
amuses85117942amuses
anes45255932a_nes
angles74426702angles
antes56334322antes
anus47131112anu_s
anuses66218772anuses
apes66047432a_pes
apres75426402apres
apses76823912apses
aquas142412612aquas
ares45871022a_res
argles75218482argles
argue64818442argue_
argued84311172argued
arguer74510542arguer
arguers8489022arguers
argus66716542argu_s
arguses84711742arguses
arles56735742arles
arses55733872arses
arums75517832arums
ashes86230612ashes
asses55629282asses
ates45047922a_tes
auger64922472auger
augers73818702augers
augurs7399962augurs
auks85525262a_uks
aures55137092aures
aves76142602a_ves
awes76037552a_wes
axes117337852a_xes
axles125219472axles
ayes76543512a_yes
azures15510182azures
baguet9316102baguet
baguets1037482baguets
blues75127042blues
cages85936012cag_es
cangues10611822cangues
clues74623032clues
cues65438982_cues
dagoes85714602dagoes
dues56045502_dues
eagles73819162eagles
eagres74014572eagres
flues84626922flues
fugues104511682fugues
gaes56348032_gaes
gages74529972gages
gales65442482gales
games86238552games
gangues9149752gangues
gapes86030822gapes
gases65633992gases
gates65939502gates
gauds75717722gauds
gauges85915992gauges
gaums86217072gaums
gaurs66317992gaurs
gauss65613452gauss
gauzes164710632gauzes
gazes155425912gazes
gees55647882_gees
gies55641422_gies
gigues8128992gigues
glues65125682glues
goes55644092_goes
grues65721962grues
gudes74520812_gudes
guess64213362_guess
guest65225922_guest
gules64831042_gules
guls55930852_guls
gums75030942_gums
guns55533482_guns
guts56637252_guts
guvs85816812_guvs
guys85019642_guys
hues75235232_hues
kagus105812032kagu_s
kues86426772_kues
lagunes8148522lagunes
langues81211912langues
leagues837942leagues
lues45943552_lues
luges65928752luges
mages85036022mag_es
maguey1236832maguey
magueys1333942magueys
magus85318752magu_s
moues75732842moues
ogees65119142ogees
ogles65223182ogles
ogres65818632ogres
pages85235072pag_es
plagues103311062plagues
ragees74618662ragees
rages64539442rag_es
rogues74617672rogues
roues56039352roues
rues46044482_rues
sages65339062sag_es
segues7412072segues
slues54527172slues
spues75025382spues
sues46247652_sues
togues76014242togues
trues54925322trues
ungues7412122ungues
vague96513112vague_
vaguer10448442vaguer
vaguest1137332vaguest
vagus96713812vagu_s
values94314942values
vogues104011922vogues
wages95330932wag_es

Search took 2 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 Filter178691538000.0802233637.5
2DLD Change Limit538001721.48336277.8
3Display Results1721720.0463739.1
 (SQL Overall)1786911721.609111057.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.