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

214 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
ammeter114839(None) 
ammeters1237691ammeters
ambeer104511602ambe_er
ameer75618982a_me_er
atmometer1346202atmometer
dimeter10411892dimeter
hammerer15278142hammerer
meeter83616502_meeter
meter75130322__meter
ohmmeter1543612ohmmeter
yammerer15225482yammerer
yawmeter1693872yawmeter
abater85518123a_bater
abetter958323abetter
aborter939933aborter
absenter1086773absenter
abutter957513abutter
acceder1235363acceder
accepter14144933accepter
acuter84412863a_cuter
adapter1036173adapter
adepter1036113adepter
adherer1137573adherer
admirer1035523admirer
admitter1135113admitter
adopter1036763adopter
aerometer11410203aerometer
aether94213673a__ether
affecter1644523affecter
after85719793a__fter
agamete1037403agamete_
agametes1147293agametes
aimer75926823aim__er
alerter72111513alerter
algometer1246533algometer
aliener71011193aliener
alleger8319633alleger
almemar1144303almemar
almner85710723alm_ner
almoner949383almoner
alter54828503a__lter
alterer72713993alterer
altimeter1146613altimeter
amasser9418733amasser
amateur933883amateur
ambeers11428923ambe_ers
amber94523213a_m_ber
ambler104916453a_mbler
ameers84015573a_me_ers
amender10349613amender
amercer1146373amercer
ammine10314493ammine_
ammines11312673ammines
ammocete1444443ammocete_
ammocetes1544313ammocetes
ampere10514413ampere_
amperes11313983amperes
ampler104313303a_mpler
amputee1148863amputee
amreeta945163amreeta
amuser84712623a_muser
anemometer1444843anemometer
animater101512393animater
anteater8311603anteater
apter76120203a__pter
arbiter939933arbiter
arete56031353a_rete_
aretes64425353a_retes
armer76924443arm__er
armet76739453armet__
armets84918353armet_s
armiger1036253armiger
armorer9259913armorer
arrester839253arrester
assenter867703assenter
asserter877573asserter
aster55434893a__ster
atmometers1445873atmometers
attester836503attester
augmenter1254123augmenter
averter102410553averter
awaiter1057443awaiter
barometer13189043barometer
bimester1236163bimester
biometer1239603biometer
catheter1338153catheter
cementer1239193cementer
cemetery1554923cemetery
comether1537253comether
commenter151410693commenter
commuter143010153commuter
coveter122912063coveter
dammer114317933damm__er
damneder1243763damneder
dampener1335533dampener
dasymeter1553503dasymeter
deter65028043__deter
diameter1148053diameter
dieter73516773_dieter
dimeters11411093dimeters
emeer74815363_eme_er
emitter93211083emitter
emmer94314463emm__er
emmet94221383emmet__
emmets10349153emmet_s
emoter85415193_emoter
fleeter103210363fleeter
fomenter1339263fomenter
gamester1137323gamester
gamete9313593gamete_
gametes10312253gametes
gammer1112318333gamm__er
gammier123711193gamm_ier
gammoner1345153gammoner
gasometer1267083gasometer
geometer1138423geometer
greeter82812673greeter
hammer138120033hamm__er
hammered16218853hammered
hammerers16216563hammerers
hammier143510653hamm_ier
hamperer15379093hamperer
hamster12810423hamster
immenser1244173immenser
impeder12438533impeder
imputer1136533imputer
jammer174014133jamm__er
jammier18408023jamm_ier
lamenter1038863lamenter
lamister1037653lamister
lamster9109913lamster
limiter92710853limiter
mameyes14376983mameyes
mammate104411273mammate_
mammee94417853mamme_e_
mammees104411143mamme_es
mammer94218863mam_mer
mammered12237653mammered
mammet94319253mammet__
mammets103911113mammet_s
mamzer19459833mam_zer
manometer1368763manometer
marketer1437383marketer
masseter1037063masseter
master84831343_master
mater74438863__mater
matter84325343_matter
meeker12359983_meeker
meeters94714543_meeters
melter83520113_melter
member12258853_member
merer75126233__merer
mete64438133__mete_
meted85424433__meted
meteor84910073__meteor
meters85625833__meters
metes74736213__metes
metier83517693__metier
metre74821303__metre
milter84921233_milter
minter84425103_minter
mister84728563_mister
miter75734793__miter
molter84119423_molter
mooter83921093_mooter
muster84724523_muster
muter74525543__muter
mutter84418883_mutter
nanometer1167783nanometer
odometer1147413odometer
ohmmeters1643783ohmmeters
omitter9298503omitter
orometer10310703orometer
osmometer1345203osmometer
oximeter1755153oximeter
pamperer14228333pamperer
parameter1349123parameter
peter74427593__peter
quieter162810333quieter
rammer103519653ramm__er
rammier112811023ramm_ier
ratemeter1145283ratemeter
remoter94815973remoter
rimester1037813rimester
riveter10208753riveter
salimeter1157373salimeter
salometer1188693salometer
semester1038903semester
sheeter103814913sheeter
skeeter113410413skeeter
smarter94113133smarter
smatter93613333smatter
smelter93311913smelter
smiter83616413_smiter
stammerer1344063stammerer
sumpter1138873sumpter
sweeter103212003sweeter
tamperer12248893tamperer
taximeter1844413taximeter
teeter65420313_teeter
tempter11358213tempter
trammeler1343223trammeler
trimeter10310083trimeter
tweeter10288533tweeter
udometer1146333udometer
unmiter9310393unmiter
ureter6313203_ureter
vomiter1237953vomiter
wattmeter1443723wattmeter
yammer133713183yamm__er
yammered16225763yammered
yammerers16214453yammerers
yawmeters1783873yawmeters
zymometer25847353zymometer

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 Filter1786911340270.406440125.6
2DLD Change Limit1340272146.12621878.4
3Display Results2142140.0762815.8
 (SQL Overall)1786912146.60827041.6
 
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.