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 “amtrac” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

208 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
amtrac1010912(None) 
amtrack15107391amtrack
amtracs1198881amtracs
amoral8314632amoral
amtracks1696632amtracks
antra56521922antra_
antral65719412antral
astral66919282astral
astray95615542astray
attract9511832attract
aboral8314373aboral
abstract1249223abstract
acta69524803act_a_
actual8311023actual
admiral1046363admiral
affray1534973affray
agaric93513633agaric
agora6914333agora_
agorae7511203agorae
agoras7613343agoras
almanac1156033almanac
altar55520643alt_ar
altars64518153altars
ama510853303am__a_
amah98927493am__ah
amarna839793amarna
amas67746293am__as
ambari103012173ambari
ambary134010543ambary
ambry123512103ambr_y
ambsace1355963ambsace
ameba9312383ameba_
amebae1049633amebae
ameban1039093ameban
amebas10311453amebas
amebic1239113amebic
amerce10310513amerce
amesace1147733amesace
amia66836903am_ia_
amias75831473am_ias
amidic114012873amidic
amiga85514813amiga_
amigas95912173amigas
aminic104413513aminic
amir65129753amir__
amirate91115953amirate
amirs75924923amir_s
amnia75918643amnia_
amnic95516243am_nic
amort75832203amor_t
amylic13108713amylic
anorak1038923anorak
anta46839583ant_a_
antae56828293ant_ae
antas55432033ant_as
anthrax1757153anthrax
antiar6317173antiar
antic75728863ant_ic
antre55224523antr_e
antres65021003antres
antrum8611313antrum
anural65714743anural
anuran64313243anuran
anuric8812103anuric
aorta55922573aorta_
aortae65115473aortae
aortal65217513aortal
aortas65417783aortas
aortic8316613aortic
apteral9311523apteral
arak86929573a__rak
arc510250903a__r_c
arrack121110253a_rrack
arras55626133a_rras
array86317143a_rray
artal55525473art_al
ashram1139053ashram
ashtray13805553ashtray
astrals75515243astrals
astrict9614793astrict
atap66722453a_t_ap
atlas55821583a_tlas
atma68121773a_tma_
atman75520143a_tman
atmas75721013a_tmas
atria56022343a_tria
atrial65418943a_trial
atrip75315753a_trip
attach11118393a_ttach
attack12148153a_ttack
attar56516693a_ttar
attars64515313attars
attic75618353a_ttic
attracts1047793attracts
attrit6315753attrit
aura45836253a_ura_
aurae54128113a_urae
aural54428963a_ural
aurar54420253a_urar
auras55932553a_uras
auric74521733a_uric
austral73411513austral
autarch1246623autarch
betray111511443betray
caltrap11297943caltrap
cambric1537383cambric
camera10313693camera_
camerae11312063camerae
cameral11311283cameral
cameras11313363cameras
cantrap113310283cantrap
citral81113893citral
citric102812313citric
detract101414633detract
embrace1388893embrace
entrap8710563entrap
estral64716513estral
estray95713333estray
extra1239003extra_
extract16311013extract
extras13310223extras
gastral8329553gastral
gastric1038633gastric
hatrack1638213hatrack
iatric8312163iatric
mac78053933_m__ac
madras94316433madras
maniac103917973maniac
mantra84116093mantra_
mantram114011603mantram
mantrap11379823mantrap
mantras93815863mantras
mantric11311343mantric
mara67444573_mara_
maraca10314153_maraca
maras75443283_maras
marc87034633_mar_c
marram10313883marram
matrass939403matrass
matres84522233matres
matrix1539843matrix
matron83918313matron
matsah1138233matsah
matza16311813matza_
matzah2035963matzah
matzas1749703matzas
merc87225623_mer_c
metric10314673metric
mitral81314323mitral
mora66641273_mora_
morae75831193_morae
moral75533433_moral
moras76438773_moras
moray105423793_moray
mura65633293_mura_
mural75225103_mural
muras75329573_muras
nitric82512063nitric
ostraca937823ostraca
outrace92418553outrace
outran63218893outran
rattrap945263rattrap
retrace91417343retrace
retrack131310723retrack
retract91318113retract
retral64419743retral
ricrac1037013ricrac
samara8313853samara_
samaras9312913samaras
samurai945923samurai
satrap86212553satrap
serac75925203_serac
strap77925263_strap
straw813321293_straw
stray88525573_stray
sutra54217933sutra_
sutras64818593sutras
tamarack1644363tamarack
tamarao977593tamarao
tamarau9107063tamarau
tambac122210243tam_bac
tantra63713353tantra_
tantras73112093tantras
tantric939583tantric
tetra53417953tetra_
tetrad73612053tetrad
tetras63017623tetras
trace75829613__trace
track114823013__track
tract75635713__tract
trad55630913__trad
tram67034553__tram
trap67532803__trap
tray77632593__tray
triac74116373__triac
ultra539363ultra_
ultras6310193ultras
umbra948513umbra_
umbrae1038683umbrae
umbral1038633umbral
umbras1038643umbras
umiac938963um_iac
untrack1338703untrack
vambrace1743983vambrace
vitric112510113vitric
yantra9449623yantra_
yantras10259003yantras
yttric1145433yttric

Search took 7 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 Filter1786911127160.376475242.0
2DLD Change Limit1127162085.89019136.8
3Display Results2082080.0762736.8
 (SQL Overall)1786912086.34228175.8
 
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.