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

209 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
alec6643006(None) 
ale36572341ale_
alecs76620731alecs
alee46652321alee
alef76340691alef
ales47067101ales
abed79734132abed
abet610547942abet
able66340532able_
abled86926832abled
abler75624312abler
ables75935542ables
ace59656832ace_
aced79540882aced
aces67645092aces
ae212590292a_e_
age47154332age_
aged67334252aged
agee56241492agee
ager55935842ager
ages55844592ages
aglee65728492aglee
aglet65534142aglet
agley96917332agley
ahed89536252ahed
ahem97225362ahem
ailed66240282ailed
ajee115928232ajee
akee85936812akee
al210674042al__
ala312463602al_a
alack114820062alack
alae45643752alae
alan46844082alan
alar46340072alar
alas46358122alas
alb57342652al_b
alba68328332alba
albs68628572albs
alder65421912alder
alefs87319662alefs
aleph10311392aleph
alert54740652alert
alfa77624272alfa
alga57927602alga
alien56425582alien
alif76242142alif
alit46155692alit
alky115920342alky
all36148232al_l
allee54932122allee
alley85721672alley
alls46740922alls
ally76935642ally
alma66333022alma
alme65832162alme
almeh106214552almeh
almes75126542almes
alms65834922alms
aloe45540192aloe
aloes54933672aloes
alow75328592alow
alp56641132al_p
alps65529242alps
als36663022al_s
also46423442also
alt36467962al_t
alter54828502alter
alto47831262alto
alts46639902alts
alum65227612alum
amen66733152amen
ane37866942ane_
anes45255932anes
anew76623132anew
ape57251182ape_
aped78538152aped
aper66336232aper
apes66047432apes
apex137220212apex
arc510250902a_rc
are37874572are_
area45843392area
areca75618632areca
areic73219392areic
ares45871022ares
arles56735742arles
asea46327182asea
ate37059242ate_
ates45047922ates
aulic74420242aulic
ave67748702ave_
aver75931882aver
aves76142602aves
awe67746622awe_
awed88436032awed
awee76336642awee
awes76037552awes
axe108239492axe_
axed128829612axed
axel115222072axel
axes117337852axes
axle116424602axle_
axled135315812axled
axles125219472axles
aye67151762aye_
ayes76543512ayes
bale66353842bale_
baled85436442baled
baler75635272baler
bales76250082bales
bleb85425222bleb
bled75729312bled
blet66247672blet
blew94722432blew
bloc85023272bloc
clef97028182clef
clew95520572clew
dale55643982dale_
dales66439742dales
elect74327032elect
exec135313942exec
flea75628492flea
fleck148213592fleck
fled85429772fled
flee76238792flee
flew105824252flew
flex146123472flex
fley106626852fley
flic96223732flic
floc95922122floc
gale56347322gale_
galea64722932galea
gales65442482gales
gled65631142gled
glee55239062glee
gleg66219802gleg
glen56027202glen
gley85724652gley
hale76052832hale_
haled95335822haled
haler85033522haler
hales85449842hales
ilea45931462ilea
ileac75814172ileac
ilex115822032ilex
kale86533752kale_
kales95730982kales
lac510155822_lac
lace66848472lace
laic65931562laic
lea37660182_lea
lech96825442_lech
led46254552_led
lee36068142_lee
leg46446112_leg
lei36846382_lei
lek75640302_lek
les35663072_les
let36481472_let
leu36047402_leu
lev66139422_lev
lex107943822_lex
ley66246812_ley
lez125541312_lez
male66052292male_
males75049792males
malic94525662malic
naled65525052naled
ole37155212ole_
olea46532722olea
oleic7313332oleic
oleo46630482oleo
oles46453472oles
pale66055012pale_
palea75028662palea
paled85538722paled
paler75436932paler
pales75753802pales
palet74650802palet
pec76744412_pec
plea66830602plea
pleb86123812pleb
pled75231432pled
plew97222812plew
plex137321372plex
rale45050562rale_
rales54947492rales
rec55645462_rec
sale44959702sale_
salep77022952salep
sales56055592sales
salic73424712salic
sec55945322_sec
sled55334372sled
slew76228232slew
spec85821972spec
talc66226812tal_c
tale46154162tale_
taler56034862taler
tales55451372tales
vale74937342vale_
vales85434262vales
valet84337872valet
wale74546432wale_
waled94330992waled
waler84229262waler
wales86142832wales
ylem9217892ylem

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.0762351197.4
2DLD Change Limit298722091.00029872.0
3Display Results2092090.0464543.5
 (SQL Overall)1786912091.122159261.1
 
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.