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

194 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
alates6483396(None) 
abates85825031abates
ablates92416901ablates
agates76121341agates
alate55340321alate_
alated75625141alated
elates65032361elates
malates93522601malates
palates93624931palates
plates85432241plates
slates64934061slates
abases85720772abases
abate76627842abate_
abated95918452abated
abater85518122abater
abaters95115202abaters
abatis84317932abatis
ablate82219212ablate_
ablated102513442ablated
acutes83917722acutes
acylates1339742acylates
adages8412952adages
adulates9311912adulates
aerates74627492aerates
agapes95212412agapes
agate66525152agate_
agaves104611512agaves
agnates82813192agnates
alae45643752ala_e_
alamos8415002alamos
alands75418372alands
alane56135612alane_
alans55636172ala_ns
alants67722022alants
alarms85913052alarms
alas46358122ala__s
albatas938372albatas
albites9313202albites
alcades101011472alcades
ales47067102al__es
aliases7914492aliases
alines65735222alines
alkanes113812932alkanes
alkies104518092alkies
allees64521482allees
allies63827672allies
almes75126542al_mes
aloes54933672al_oes
altars64518152altars
alter54828502al_ter
alters64924222al_ters
altos55822952al_tos
alts46639902al_t_s
amazes175613472amazes
anlaces92313732anlaces
anlages82414112anlages
anlases72514902anlases
annates72415422annates
antes56334322a_ntes
aplites9314932aplites
arames84622572arames
aretes64425352aretes
ates45047922__ates
atlantes838552atlantes
atlases72410642atlases
atlatls744772atlatls
aviates10313062aviates
awakes135012472awakes
axites134913832axites
azotes154312222azotes
balases93815432balases
balatas9311832balatas
bates75846342_bates
blades95221252blades
blames105121862blames
blares85021632blares
blate75933782blate_
blats75132502blat_s
blazes174817352blazes
blites84721212blites
carates95630612carates
cates75951892_cates
clades94920462clades
claves115020062claves
crates85736062crates
dates65639152_dates
dealates92716682dealates
delates83526282delates
dilates83220662dilates
elate55335882elate_
elated74725822elated
elater64724202elater
elaters74420192elaters
elites66027122elites
eluates72014682eluates
elutes64020312elutes
enates64026432enates
fates85139232_fates
flakes134118872flakes
flames114723692flames
flanes94522422flanes
flares94521702flares
flats86429742flat_s
flatus94310782flatus
flaxes165015352flaxes
flites95122442flites
flutes95421782flutes
flytes123911562flytes
folates103218452folates
galatea839952galatea
galateas937132galateas
galaxes1538872galaxes
gallates92815522gallates
gates65939512_gates
gelates83219582gelates
glaces94218022glaces
glades84820342glades
glares75518862glares
glazes165315642glazes
glutes74517672glutes
grates75429892grates
halites103221192halites
hamates122917682hamates
hates86742572_hates
karates115617472karates
laces76141762_laces
lades65141272_lades
lakes95737652_lakes
lames75445542_lames
lanes54946792_lanes
lares54852632_lares
lases54944762_lases
late47560482_late_
lated65240672_lated
laten54328342_laten
latens64620212_latens
later54843922_later
latest63822702_latest
latex124717112_latex
lathes95127492_lathes
laths86022402_laths
latkes104715872_latkes
lats45962702_lat_s
lattes65324202lattes
laves86039152_laves
laxes125430092_laxes
lazes145129572_lazes
lutes55836662_lutes
malate84624552malate_
maleates103316342maleates
mates75251362_mates
nates55238332_nates
oblates91913242oblates
oleates7417832oleates
orates64328612orates
oxalates1557062oxalates
palaces114216452palaces
palate84226782palate_
palpates122613062palpates
pates76047892_pates
places104323702places
plages94520152plages
planes85028082planes
plate74635112plate_
plated95225772plated
platen84518202platen
platens94213982platens
plater84427692plater
platers93924092platers
platies93722542platies
plats75531372plat_s
platys11459852platys
prates84633162prates
rates55352012_rates
relates73731432relates
salutes73716252salutes
sates54949322_sates
savates10312952savates
skates104219402skates
slakes104021882slakes
slate55438282slate_
slated75028312slated
slater64429182slater
slaters73123732slaters
slatey95417062slatey
slats55436902slat_s
slaves95023022slaves
solates73523852solates
spates85028172spates
states64337082states
tates55444982_tates
urates65027762urates
vacates12312832vacates
valuates112811202valuates

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 Filter178691825510.343520965.0
2DLD Change Limit825511942.32635490.5
3Display Results1941940.0633079.4
 (SQL Overall)1786911942.73265406.7
 
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.