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

281 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
applier113790(None) 
applied1247481applied
appliers1235571appliers
applies11311221applies
ampler104313302ampl_er
apple94517672appl_e_
apples104315762appl_es
applet105917432appl_et
apposer1147482apposer
appriser1246782appriser
apprizer2145462apprizer
atelier7311642atelier
gappier12369842gapp_ier
happier143312042happ_ier
nappier114411172napp_ier
palier85023572_palier
pallier94417172pallier
pappier103511602pappier
plier75221282__plier
replier94214972replier
ripplier1234462ripplier
sappier113613122sapp_ier
supplier1246602supplier
zappier20458372zapp_ier
abler75624313a_bl_er
achier113914263a_chier
aerier64823163a_erier
airier64619363a_irier
airliner836963airliner
alder65421913a__lder
alien56425583a__lien
aliner65621993a__liner
allied74217153a_llied
allies63827673a_llies
alter54828503a__lter
ambler104916453ambl_er
ample94720303ampl_e_
amplifier16104703amplifier
amplify1744083amplify
angler74017863angl_er
angrier839023angrier
antler64615553antl_er
antsier7410773antsier
apelike13310533apelike
aper66336233a_p__er
aperies9423203aperies
aplite8316393a_plite
aplites9314933a_plites
appalled1344813appalled
apparel1146003apparel
appealer1245743appealer
appear10379343app_ear
appeaser1245953appeaser
appel94615893app__el
appellee1246253appellee
appellor1243583appellor
appetiser1344443appetiser
appetizer2244433appetizer
applaud1293903applaud
applauder1442363applauder
applets115710063applets
applique2142583applique
appliqued2341953appliqued
appliques2242553appliques
apply125111393appl__y
applying1634653applying
appoint11612483appoint
appointer1354423appointer
appose10411993appose_
apposed1247853apposed
apposers1236283apposers
apposes11511473apposes
appraiser1344953appraiser
apprise11310193apprise
apprised1337713apprised
apprisers1345053apprisers
apprises12310963apprises
apprize2038183apprize
apprized2236543apprized
apprizers2243833apprizers
apprizes2137793apprizes
approver15105303approver
appulse1134673appulse_
appulses1234893appulses
apter76120203a_p_ter
artier63419733a_rtier
artsier768943artsier
ashier94714833a_shier
ashler9459973ashl_er
asper75520433asp__er
aspire8612123asp_ire
aspirer967903aspirer
ateliers837903ateliers
aulder7511453a_ulder
auntlier834903auntlier
belier84423563_belier
bullier94116433bullier
burlier93514413burlier
campier133313273camp_ier
caponier1237883caponier
capper124421983capp__er
cavalier1348183cavalier
coalier93416183coalier
collier93618153collier
complier14310253complier
copier103722903cop_ier
crappier14288143crapp_ier
cuppier1368323cuppier
curlier93314183curlier
dallier84215383dallier
danglier1056753danglier
dapper114016633dapp__er
dapperer1335763dapperer
dapple1138853dappl_e_
dappled1336393dappl_ed
dapples1238993dappl_es
dappling1436843dappling
darklier1335013darklier
dimplier1336673dimplier
dippier123111393dippier
dopier93515923dop_ier
earlier72612753earlier
eelier64216463_eelier
emptier1187603emptier
espalier1036363espalier
flappier1544303flapp_ier
flier86023403__flier
gainlier965673gainlier
ganglier1047603ganglier
gasalier936443gasalier
gaselier946973gaselier
gasolier935833gasolier
girlier8289523girlier
godlier938893godlier
grappler13336193grappl_er
gulpier1046953gulpier
hacklier1737133hacklier
haulier1059943haulier
hillier103413963hillier
hippier143212103hippier
holier94921623_holier
hoppier143110703hoppier
implied1238623implied
implies11312123implies
inlier63615363_inlier
janglier1656113janglier
jollier142911003jollier
jowlier17327563jowlier
lapper104319953lapp__er
lavalier1146043lavalier
lier45942473___lier
lippier112710573lippier
loppier11369723loppier
lowlier10338903lowlier
manlier92414033manlier
mapper124516093mapp__er
marblier1256353marblier
marlier92614793marlier
mealier93015903mealier
millier93716703millier
mopier103914783mop_ier
motlier92010583motlier
napper103718283napp__er
nappie104112263napp_ie_
nappies114613403napp_ies
nippier11319833nippier
oilier64417233_oilier
opposer1135773opposer
outlier72216143outlier
pacier105018683_pacier
paler75436943_pal_er
palmer105816543_palmer
palmier113312183palmier
palter84423263_palter
panier84425503_panier
pannier93613353pannier
paper95128663pap__er
paperer113111903paperer
pappies103214833pappies
parrier93717653parrier
partier93520713partier
pastier94320383pastier
pawkier16236613pawkier
pelter83321623_pelter
peppier10268323peppier
pier66035303__p_ier
pilfer1139163_pilfer
pimplier1445413pimplier
pinier84024693_pinier
pipier104913983_pipier
pitier84019823_pitier
plie65127393__plie_
plied85118593__plied
pliers84715153__pliers
plies74526513__plies
plyer106214333__plyer
pokier124914633_pokier
polder94019253_polder
poler74431793_pol_er
policer113112683_policer
polies84034583_polies
politer92417073_politer
poller83921853_poller
poxier153812113_poxier
prier75027763__prier
puler74826623_pul_er
puller83820813_puller
pulper103513273_pulper
pulpier1148623_pulpier
pulser84215193_pulser
punier84519233_punier
rallier73816283rallier
rapier84019993rap_ier
rapper104621573rapp__er
raspier93110643rasp_ier
reapplied1443683reapplied
reapplies1344923reapplies
relier65826183_relier
replied103914463replied
repliers103710163repliers
replies94521043replies
rippler113210103rippl_er
roilier7311523roilier
ropier84118813rop_ier
rulier65016353_rulier
rumplier1235303rumplier
sallier73320433sallier
sampler113212013sampl_er
sapper103822353sapp__er
sapphire1543803sapphire
scalier94316913scalier
shalier103116423shalier
shapelier1444463shapelier
sillier74017593sillier
slier54827243__slier
snappier1266223snapp_ier
soppier112711583soppier
spacier114011633spacier
spaller92713473spaller
speller95415153speller
spelter94113703spelter
spicier115112463spicier
spier75728033_sp_ier
spikier13369983spikier
spiller92914333spiller
spinier93715163spinier
spirier93214073spirier
splicer114710523_splicer
spoiler93310683spoiler
sprier84119063_sprier
spumier1137903spumier
suppler1148443suppl_er
supplied1345993supplied
suppliers1354483suppliers
supplies1268843supplies
surlier72915443surlier
tallier72817223tallier
tanglier948073tanglier
tapper104419613tapp__er
tippier113210543tippier
tippler11348343tippl_er
tipsier9268893tipsier
typier1137333typ_ier
uglier748953_uglier
unapplied1443743unapplied
upper93714263upp__er
uppile10178503uppile_
uppiled12216593uppiled
uppiles11208263uppiles
vampier14308233vamp_ier
vealier102712173vealier
wabblier15375493wabblier
wafflier1733953wafflier
wagglier1344323wagglier
wamblier15275733wamblier
waspier12259053wasp_ier
wilier93217073_wilier
woolier103612353woolier
yapper133714513yapp__er
zapper193414023zapp__er
zippier20308193zippier

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 Filter1786911340270.440406115.9
2DLD Change Limit1340272817.32618294.7
3Display Results2812810.1102554.5
 (SQL Overall)1786912817.87622688.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.