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

218 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
alate5534032(None) 
abate76627841abate
ablate82219211ablate
agate66525151agate
alae45643751ala_e
alane56135611alane
alated75625141alated
alates64833961alates
blate75933781blate
elate55335881elate
late47560481_late
malate84624551malate
palate84226781palate
plate74635111plate
slate55438281slate
abase76023482abase
abated95918452abated
abater85518122abater
abates85825032abates
ablated102513442ablated
ablates92416902ablates
ablaze17239832ablaze
acuate8315632acuate
acute74720362acute
acylate12310532acylate
adage7414052adage
adnate72913482adnate
adulate8313232adulate
aerate64830552aerate
aflame1138722aflame
agape85614842agape
agates76121342agates
agave95314032agave
agaze156113662agaze
aglare7312422aglare
agnate73314882agnate
ala312463602ala__
alack114820062alack
alamo7418142alamo
alan46844082ala_n
aland65526412aland
alang66023512alang
alans55636172alans
alant55742292alant
alants67722022alants
alar46340072ala_r
alarm76621422alarm
alary86123442alary
alas46358122ala_s
albata839332albata
albite8313312albite
alcade91111512alcade
ale36572342al__e
alee46652322al_ee
algae65319622algae
alike95523962alike
aline57243152aline
alit46155692alit_
alive85722512alive
alkane104313322alkane
alkie95520032alkie
allee54932122allee
alme65832162al_me
aloe45540192al_oe
alone55732962alone
alt36467962al_t_
altar55520642altar
alter54828502al_ter
alto47831262al_to
alts46639902al_ts
amaze166016602amaze
anlace82513922anlace
anlage72514232anlage
ansate64517862ansate
antae56828292antae
ante46538902a_nte
apace94718382apace
aplite8316392aplite
arame75026622arame
arete56031352arete
ate37059242__ate
atlatl637872atlatl
aurate64426472aurate
aviate9315202aviate
awake125014782awake
aware86420022aware
axite125218252axite
azote144416342azote
balata8614672balata
bate66552422_bate
blade85923332blade
blae66134642bla_e
blame95625492blame
blare75826232blare
blase75524232blase
blat66550952blat_
blats75132502blats
blaze165520832blaze
blite76225352blite
carate84734002carate
cate66254602_cate
clade85821012clade
clave105420152clave
crate76537402crate
date56443322_date
dealate83617842dealate
delate73827752delate
dilate73220692dilate
elated74725822elated
elater64724202elater
elates65032362elates
elite56230182elite
eluate62315432eluate
elute54822572elute
enate54428152enate
falcate12311612falcate
fate75444282_fate
flake125119972flake
flame105124442flame
flare84823632flare
flat77147822flat_
flats86429742flats
flite85424962flite
flute86823752flute
flyte115713942flyte
folate93320392folate
galatea839952galatea
galeate83916782galeate
gallate83417122gallate
gate55746572_gate
gelate73421252gelate
glace87420152glace
glade75121962glade
glare65222952glare
glaze155418162glaze
glute66020902glute
grate64932882grate
halite93624232halite
hamate113319832hamate
hate78450172_hate
irate55627982irate
karate105320922karate
lace66848472_lace
lade56345982_lade
lake85741602_lake
lame66849292_lame
lanate6421262lanate
lane45153332_lane
lase46148512_lase
lat37593402_lat_
lated65240672_lated
laten54328342_laten
later54843922_later
latex124717112_latex
lath76640382_lath
lathe85626712_lathe
lati46438272_lati
latke94817092_latke
lats45962702_lats
latte55426302latte
latu47934182_latu
lave75642142_lave
laze136235052_laze
lite47054542_lite
lute46341012_lute
malates93522602malates
maleate94117542maleate
mate65154222_mate
oblate82214742oblate
oleate6318882oleate
orate55133302orate
ovate84214392ovate
oxalate1457622oxalate
palace104516912palace
palates93624932palates
paleate94120002paleate
palmate113215232palmate
palpate113213922palpate
pate65350462_pate
place94824612place
plage84520402plage
plane74929142plane
plat66048872plat_
plated95225772plated
platen84518202platen
plater84427692plater
plates85432242plates
plats75531372plats
platy105021662platy
prate75135982prate
quate144521412quate
ramate83921682ramate
rate45458762_rate
relate64033632relate
salute64418022salute
sate45556102_sate
savate9313782savate
skate94721552skate
slake93724052slake
slat46959022slat_
slated75028312slated
slater64429182slater
slates64934062slates
slatey95417062slatey
slats55436902slats
slaty86523152slaty
slave84224032slave
solate64526072solate
spate74731582spate
state56237332state
tate44748602_tate
urate55432162urate
vacate11314552vacate
vallate103016562vallate
valuate102512732valuate
valvate133710812valvate
velate93720142velate
zlote143912942zlote

Search took 3 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.313570897.8
2DLD Change Limit538002181.67032215.6
3Display Results2182180.0464739.1
 (SQL Overall)1786912182.02988068.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.