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

189 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
armer7692444(None) 
aimer75926821aimer
armed86324431armed
armers85520271armers
armet76739451armet
armor75118051armor
farmer115017371farmer
harmer114719551harmer
ormer75218371ormer
warmer113816731warmer
abler75624312abler
acme86924322acme_
acmes96020652acmes
adder75419592adder
admen84516182admen
aerier64823152aerier
after85719792after
ager55935842a_ger
agger76420892agger
aider65431132aider
aimed85626052aimed
aimers84621912aimers
airer54927892airer
airier64619362airier
airmen82612352airmen
aiver85725162aiver
alder65421912alder
alme65832162alme_
almeh106214552almeh
almes75126542almes
almner85710722almner
alter54828502alter
amber94523212amber
ameer75618982ameer
amen66733152a_men
amir65129752a_mir
anger66225872anger
aper66336232a_per
apter76120202apter
arame75026622arame_
arames84622572arames
arbor74818112arbor
arced88224162arced
archer115016242archer
ardeb8314522ardeb
ardor64617862ardor
are37874572ar_e_
area45843392ar_ea
ares45871022ar_es
arguer74510542arguer
arider74717742arider
ariel55228972ariel
arles56735742arles
arm58449622arm__
armets84918352armets
armies85123692armies
armiger1036252armiger
armlet84118192armlet
armorer9259902armorer
armors85017812armors
armory114211472armory
armour84411852armour
arms66137492arm_s
armure8710132armure
army96624182arm_y
arpen74418042arpen
arrear6310252arrear
arse46539272arse_
arses55733872arses
artel56122742artel
artery9911452artery
artier63419732artier
asker96418782asker
asper75520432asper
aster55434892aster
auger64922472auger
aver75931882a_ver
axmen145112272axmen
barber104419322barber
barer74535802bar_er
barker124822862barker
barmen105418532barmen
barmier114313042barmier
barter85525372barter
brier74527402brier
calmer105216932calmer
carder94524182carder
career85822242career
carer74942332car_er
carmen104019342carmen
carper104923632carper
carter84932272carter
carver114420142carver
charmer144913662charmer
comer95832692comer
crier74724462crier
dammer114317932dammer
darer65230792dar_er
darker114718692darker
darner74017302darner
darter75320362darter
dimer85625602dimer
dormer94415892dormer
drier64423962drier
dryer95111462dryer
earner63617222earner
emmer94314462emmer
farcer115016082farcer
farer86733142far_er
farmed125117652farmed
farmers124315262farmers
firmer114712442firmer
former114221402former
framer114817442framer
freer86021242freer
frier85225842frier
fryer115913432fryer
fumer105918232fumer
gamer84928942gamer
gammer1112318332gammer
garner73917002garner
garter74420512garter
gomer85220652gomer
hammer138120032hammer
harder105022402harder
harmed125218832harmed
harmers124116592harmers
harper115018402harper
homer105828452homer
jammer174014132jammer
lamer75233702lamer
larder73720972larder
larger74417512larger
larker104519242larker
maimer104514592maimer
mammer94218862mammer
marker124420392marker
marrer83716672marrer
mimer94825762mimer
namer75622102namer
omer67028392_omer
order65019362order
ormers84316142ormers
palmer105816542palmer
parer75839902par_er
parker124121372parker
parser84822372parser
prier75027762prier
primer105118682primer
pryer104415312pryer
racer75233022racer
raker94529792raker
ramee74633852ramee
ramen75625192ramen
ramet75743142ramet
rammer103519652rammer
raper74932752raper
rarer54731702rarer
raser55633412raser
rater54943282rater
raver85631492raver
rawer84623732rawer
razer144824272razer
rimer75429242rimer
ruer46127562_ruer
swarmer1247802swarmer
tamer75230102tamer
tarter64023562tarter
termer85717252termer
timer75626042timer
trier54328532trier
trimer85717152trimer
truer54916642truer
urger64116472urger
varier94619352varier
vomer105517382vomer
warder104020272warder
warier93722892warier
warmed124516892warmed
warmers124514292warmers
warner93717222warner
warper114015582warper
wormer114514912wormer
wrier84521752wrier
wryer11489302wryer
yammer133713182yammer
yarder103813972yarder
yarer84321572yar_er
yarner93313062yarner

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.1101624463.6
2DLD Change Limit538001892.42322203.9
3Display Results1891890.1101718.2
 (SQL Overall)1786911892.64367609.2
 
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.