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

215 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
alef7634069(None) 
ale36572341ale_
alec66430061alec
alee46652321alee
alefs87319661alefs
ales47067101ales
alif76242141alif
clef97028181clef
abed79734132abed
abet610547942abet
able66340532able_
abled86926832abled
abler75624312abler
ables75935542ables
ace59656832ace_
aced79540882aced
aces67645092aces
ae212590292a_e_
aff95537612a_ff
age47154332age_
aged67334252aged
agee56241492agee
ager55935842ager
ages55844592ages
aglee65728492aglee
aglet65534142aglet
agley96917332agley
ahed89536252ahed
ahem97225362ahem
ailed66240282ailed
ajee115928232ajee
akee85936812akee
al210674042al__
ala312463602al_a
alae45643752alae
alan46844082alan
alar46340072alar
alas46358122alas
alb57342652al_b
alba68328332alba
albs68628572albs
alder65421912alder
alecs76620732alecs
aleph10311392aleph
alert54740662alert
alfa77624272alfa
alga57927602alga
alien56425582alien
alifs86121262alifs
alit46155692alit
alky115920342alky
all36148232al_l
allee54932122allee
alley85721672alley
alls46740922alls
ally76935642ally
alma66333032alma
alme65832162alme
almeh106214552almeh
almes75126542almes
alms65834922alms
aloe45540192aloe
aloes54933672aloes
aloft8423432aloft
aloof83521572aloof
alow75328592alow
alp56641132al_p
alps65529242alps
als36663022al_s
also46423442also
alt36467962al_t
alter54828502alter
alto47831262alto
alts46639902alts
alum65227612alum
amen66733152amen
ane37866952ane_
anes45255932anes
anew76623132anew
ape57251182ape_
aped78538152aped
aper66336232aper
apes66047432apes
apex137220212apex
are37874572are_
area45843402area
ares45871022ares
arf67453372a_rf
arles56735742arles
asea46327182asea
ate37059242ate_
ates45047922ates
ave67748702ave_
aver75931882aver
aves76142602aves
awe67746622awe_
awed88436032awed
awee76336642awee
awes76037552awes
axe108239492axe_
axed128829612axed
axel115222072axel
axes117337852axes
axle116424602axle_
axled135315812axled
axles125219472axles
aye67151762aye_
ayes76543512ayes
bale66353842bale_
baled85436442baled
baler75635282baler
bales76250082bales
beef96233682beef
bleb85425222bleb
bled75729312bled
blet66247672blet
blew94722432blew
calf96339562cal_f
calif104929102calif
chef125125622chef
clefs106616242clefs
cleft106222852cleft
clew95520572clew
dale55643982dale_
dales66439742dales
def76546722_def
delf85436572delf
ef57345362__ef
elf66138522el_f
fief107331372fief
flea75628492flea
fled85429772fled
flee76238792flee
flew105824252flew
flex146123472flex
fley106626852fley
gale56347322gale_
galea64722942galea
gales65442482gales
ganef96322462ganef
gled65631142gled
glee55239062glee
gleg66219802gleg
glen56027202glen
gley85724652gley
hale76052832hale_
haled95335822haled
haler85033532haler
hales85449842hales
half106238452hal_f
ilea45931462ilea
ilex115822032ilex
kale86533762kale_
kales95730982kales
kalif125021362kalif
keef115830012keef
kef105639672_kef
kief117128422kief
lea37660182_lea
leaf76441032_leaf
led46254562_led
lee36068142_lee
left76340482_left
leg46446112_leg
lei36846382_lei
lek75640302_lek
les35663072_les
let36481472_let
leu36047402_leu
lev66139422_lev
lex107943822_lex
ley66246812_ley
lez125541312_lez
lief76037002lief
male66052302male_
males75049792males
naled65525052naled
ole37155212ole_
olea46532722olea
oleo46630482oleo
oles46453472oles
pale66055012pale_
palea75028662palea
paled85538722paled
paler75436942paler
pales75753802pales
palet74650802palet
pelf97031452pelf
plea66830602plea
pleb86123812pleb
pled75231432pled
plew97222812plew
plex137321372plex
rale45050562rale_
rales54947492rales
reef74938212reef
ref66053292_ref
sale44959702sale_
salep77022952salep
sales56055592sales
self75138292self
sled55334372sled
slew76228232slew
tale46154162tale_
taler56034872taler
tales55451372tales
tref77030992tref
vale74937342vale_
vales85434262vales
valet84337872valet
wale74546442wale_
waled94331002waled
waler84229292waler
wales86142842wales
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.330541487.9
2DLD Change Limit298722150.98330388.6
3Display Results2152150.0464673.9
 (SQL Overall)1786912151.359131487.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.