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

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
egal5511943(None) 
egad64215411egad
gal46055511_gal
legal65715941legal
regal65023791regal
aal39058672_aal
aga410447232aga_
agar58726412agar
agas55938842agas
al210674042__al
algal66518212algal
anal48037522anal
argal65023382argal
axal116520492axal
baal67033112baal
bal56662722_bal
begall92610722begall
began86319572began
begat86629722begat
cecal94619112cecal
coal66939252coal
dal47554952_dal
deal56347412deal
decal85523232decal
dedal75719022dedal
degas75119162degas
dhal86719282dhal
dial55935062dial
dual55928172dual
eagle64219482eagle
ear36867882e_ar
earl45838142earl
eat36989052e_at
eau37450942e_au
eel37946842e_el
egads74610922egads
eger55923562eger
egg56918672eg_g
eggar7458882eggar
eggs66516152eggs
eggy96611852eggy
egis56520652egis
ego46726052eg_o
egos55821652egos
el26745292e__l
elan46734242elan
ell36735682e_ll
email74715092email
enol45823822enol
equal1449822equal
era35741502era_
eras45441502eras
eta35834192eta_
etas46432272etas
evil75318072evil
exalt123018532exalt
exam132514622exam
eyas76427432eyas
feal713940422feal
fecal105119212fecal
feral85424652feral
fetal85623372fetal
foal76630922foal
fugal95613032fugal
gab67155992_gab
gad57556652_gad
gae46457702_gae
gag57753632_gag
gala55635162_gala
gale56347322_gale
gall56335992_gall
gals57946502_gals
gam67060062_gam
gan48060122_gan
gaol56925412_gaol
gap67055612_gap
gar47259902_gar
gas48870252_gas
gat46880512_gat
gay76856492_gay
gear55934972gear
gel45642432_gel
goal55829302goal
gul45832792_gul
heal75645692heal
hemal104419802hemal
jugal135612402jugal
leal46043272leal
legals73412732legals
meal65643172meal
medal86221322medal
mega77620872mega_
metal75427382metal
ogam75120032ogam
opal66923522opal
oral47638122oral
oval77119522oval
pal56761672_pal
peal68648102peal
pedal86022502pedal
penal75228372penal
petal76526892petal
pial65636702pial
real45750292real
regale74821452regale
regnal74812932regnal
renal55929502renal
rial45938092rial
rugal65916092rugal
sal36462882_sal
seal45654372seal
sepal77723002sepal
seral56336382seral
setal56430902setal
sial45938832sial
teal45546502teal
tepal76319582tepal
tergal72912832tergal
vagal94613632vagal
veal76936812veal
vegan95114152vegan
venal85523212venal
vial76731092vial
weal75838682weal
zeal135530332zeal

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 Filter178691298720.0802233637.5
2DLD Change Limit298721250.90632971.3
3Display Results1251250.0304166.7
 (SQL Overall)1786911251.016175877.0
 
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.