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

180 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
ammeters123769(None) 
ammeter1148391ammeter_
ambeers11428922ambe_ers
ameers84015572a_me_ers
atmometers1445872atmometers
dimeters11411082dimeters
hammerers16216552hammerers
meeters94714542_meeters
meters85625832__meters
ohmmeters1643782ohmmeters
yammerers16214452yammerers
yawmeters1783872yawmeters
abaters95115193a_baters
abetters1057173abetters
aborters1038563aborters
absenters1156173absenters
abutters1056983abutters
acceders1334793acceders
accepters15114603accepters
adapters1136103adapters
adherers1296913adherers
admirers1134703admirers
admitters1244553admitters
adopters1136683adopters
aerometers1249463aerometers
aethers103614943a__ethers
affecters1763933affecters
afters94717073a__fters
agametes1147293agamete_s
aimers84621913aim__ers
algometers1345993algometers
alieners889823alieners
allegers9378233allegers
almemars1243523almemars
almners9399563alm_ners
almoners1068133almoners
alterers82512493alterers
alters64924223a__lters
altimeters1246353altimeters
amassers10337833amassers
amateurs1043633amateurs
ambeer104511593ambe_er_
ambers104519563a_m_bers
amblers115213563a_mblers
ameer75618983a_me_er_
amenders11288343amenders
amercers1256133amercers
ammines11312673ammine_s
ammocetes1544313ammocete_s
amperes11313983ampere_s
amputees1245103amputees
amreetas1044273amreetas
amusers94610193a_musers
anemometers1544643anemometers
animaters11129953animaters
anteaters939333anteaters
arbiters1038853arbiters
aretes64425353a_rete_s
armers85520273arm__ers
armets84918353armet__s
armigers1135703armigers
armorers10288963armorers
arresters948193arresters
assenters966993assenters
asserters956383asserters
asters65631603a__sters
atmometer1346203atmometer_
attesters935803attesters
augmenters1343513augmenters
averters11249503averters
awaiters1146643awaiters
barometers14198493barometers
bimesters1336323bimesters
biometers1339153biometers
catheters1436993catheters
cementers1338303cementers
cemetery1554923cemetery
comethers1637433comethers
commenters16139473commenters
commuters15378883commuters
coveters132411073coveters
dammers123214273damm__ers
dampeners1444663dampeners
dasymeters1643593dasymeters
deters74724683__deters
diameters1247583diameters
dieters83216423_dieters
dimeter10411893dimeter_
emeers83314183_eme_ers
emitters10349643emitters
emmers104013223emm__ers
emmets10349153emmet__s
emoters94712873_emoters
fomenters1437853fomenters
gamesters1236733gamesters
gametes10312253gamete_s
gammers123214563gamm__ers
gammoners1444563gammoners
gasometers1346643gasometers
geometers1238183geometers
greeters92610113greeters
hammerer15278143hammerer_
hammers144216053hamm__ers
hamperers16287523hamperers
hamsters13710423hamsters
impeders13346593impeders
imputers1235813imputers
jammers183710703jamm__ers
lamenters1137683lamenters
lamisters1157123lamisters
lamsters1099753lamsters
limiters10249323limiters
mameyes14376983mameye_s
mammees104411143mamme_e_s
mammers104615693mam_mers
mammets103911113mammet__s
mamzers20409163mam_zers
manometers1448023manometers
marketers1545983marketers
masseters1136283masseters
masters94628923_masters
maters85032383__maters
matters94421753_matters
meeter83616503_meeter_
melters93918313_melters
members13258603_members
meteors94610013__meteors
meter75130323__meter_
metes74736213__mete_s
metiers93312843__metiers
metres85121563__metres
milters93619083_milters
minters93822463_minters
misters93927503_misters
miters84328773__miters
molters93816973_molters
mooters93818623_mooters
musters94522493_musters
mutters94117133_mutters
nanometers1247123nanometers
odometers1247133odometers
ohmmeter1543613ohmmeter_
omitters10277653omitters
orometers11310403orometers
osmometers1444923osmometers
oximeters1855143oximeters
pamperers15236863pamperers
parameters1448113parameters
peters86624593__peters
quieters17248733quieters
rammers113715043ramm__ers
ratemeters1244993ratemeters
rimesters1137473rimesters
riveters11228153riveters
salimeters1256513salimeters
salometers1258063salometers
semesters1139113semesters
sheeters113111853sheeters
skeeters12298963skeeters
smatters104011713smatters
smelters103310513smelters
smiters93414363_smiters
stammerers1443133stammerers
sumpters1238023sumpters
tamperers13227313tamperers
taximeters1944053taximeters
teeters74018303_teeters
tempters12257293tempters
trammelers1442513trammelers
trimeters1139203trimeters
tweeters11287143tweeters
udometers1245743udometers
unmiters1037073unmiters
ureters7311823_ureters
vomiters1337203vomiters
wattmeters1543603wattmeters
yammerer15225483yammerer_
yammers143410323yamm__ers
yawmeter1693873yawmeter_
zymometers261986923zymometers

Search took 8 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 Filter1786911461620.1531167915.0
2DLD Change Limit1461621807.25320151.9
3Display Results1801800.0603000.0
 (SQL Overall)1786911807.46623934.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.