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

378 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
admire94993(None) 
admired1135701admired
admirer1035521admirer
admires1038661admires
adhere10310332adhere
adjure1435842adjure
admiral1046362admiral
admirers1134712admirers
admit8319492admi_t
admits9411412admits
admix1557732admi_x
admixed1833732admixed
admixes1765962admixes
admixt1637332admixt
adore65723672ad_ore
advice12107882advice
advise10139222advise
afire86215912a_fire
amice96122872a_mice
amide86128482a_mide
amie66339852a_mi_e
amine75835382a_mine
amir65129752a_mir_
amirs75924922a_mirs
ammine10314492ammine
armoire938132armoire
armure8710132armure
aspire8612122aspire
attire62412382attire
bemire103312802bemire
coadmire1344042coadmire
dire56644142_d_ire
mire66748232__mire
abide86223713a_bide
abjure1536743abjure
achier113914263achier
acme86924323acm__e
acmic11312333acmi_c
acquire1835603acquire
acre67330773a__cre
active11313743active
adage7414053ad_age
adamsite1144423adamsite
adder75419593adder_
adders84315703adders
addible11236063addible
addict10711203addict
adding93914963adding
addle74318353ad_dle
adduce1076453adduce
adenine8311213adenine
adhered1239233adhered
adherer1137573adherer
adheres11310163adheres
adieu6417423ad_ieu
adios65822863ad_ios
adit56443653ad_i_t
adits66523713ad_its
adjured1634883adjured
adjurer1534823adjurer
adjures1536233adjures
adman84517903adm_an
admass957143admass
admen84516183adm_en
admirable1445433admirable
admirals1144353admirals
admiring1236133admiring
admitted1234763admitted
admittee1145133admittee
admitter1135113admitter
admixture1952103admixture
adnate72913483adnate
adobe84814713ad_obe
adored84714243ad_ored
adorer74713453ad_orer
adores74420723ad_ores
adorn64917093ad_orn
adoze155713833ad_oze
adrift10313113adrift
adsorb946953adsorb
adverb12265413adverb
adverse1145953adverse
advert103215783advert
advices13136933advices
advised12136043advised
advisee11147153advisee
adviser11135783adviser
advises11138973advises
adze1412820573ad__ze
adzing174110013adzing
aedile73716653aedile
aedine73218393aedine
aerie54634603aeri_e
aerier64823153aerier
affaire1344463affaire
affine12310503affine
affirm1435523affirm
afore85818603a_fore
aggie73415013aggi_e
agile65122263a_gile
aglare7312423aglare
agnize16329563agnize
aide56045003a__ide
aimer75926823aimer_
aimers84621913aimers
aiming94320843aiming
air38058393a__ir_
aired66032923a__ired
airer54927893a__irer
airier64619363airier
airn46433833a__irn
airs46447423a__irs
airt45757783a__irt
airy75734153a__iry
albite8313313albite
alike95523963a_like
aline57243153a_line
alive85722513a_live
alkie95520033alki_e
alkine104916803alkine
allure63012943allure
alme65832163alm__e
almner85710723almner
almuce10348213almuce
almude9399933almude
alpine84417373alpine
alsike1047913alsike
alumine9412693alumine
alvine94614583alvine
amaze166016603a_maze
amber94523213a_mber
amble95924643a_mble
ambry123512103a_mbry
ameer75618983a_meer
amerce10310513a_merce
ami56646813a_mi__
amia66836903a_mi_a
amias75831473a_mias
amices105018013a_mices
amici94217393a_mici
amid77036353a_mi_d
amides95722663a_mides
amido85720983a_mido
amids85627513a_mids
amies76837693a_mies
amiga85514813a_miga
amigo86515473a_migo
amin66042253a_mi_n
amines84727983a_mines
amino75425503a_mino
amins75534323a_mins
amirate91115953a_mirate
amis66445323a_mi_s
amiss75823073a_miss
amity10416093a_mity
ammines11312673ammines
ammino1069883ammino
amole75724593a_mole
amort75832203a_mort
ampere10514413ampere
ample94720303a_mple
amuse75920833a_muse
anile54634463a_nile
anime75423203a_nime
anise55129703a_nise
anomie83215963anomi_e
antired82316193antired
antre55224523a_ntre
anymore1256243anymore
aplite8316393aplite
are37874573a___re
arise56436433a_rise
armer76924443armer_
armers85520273armers
armies85123693armies
armiger1036253armiger
arming94719803arming
armlike1348553armlike
armoires1057623armoires
armor75118053armor_
armored102610473armored
armorer9259913armorer
armors85017813armors
armory114211473armory
armures9510273armures
arrive91311793arrive
arsine64021043arsine
artier63419733artier
ashier94714833ashier
ashore9414613ashore
aside65122083a_side
aspired1068173aspired
aspirer967903aspirer
aspires9612043aspires
assize1538633assize
assure6610773assure
astir55517093astir_
aswirl935093aswirl
atomise93013823atomise
atomize183111823atomize
attired8238913attired
attires72312953attires
audile73315303audile
augite7312613augite
avodire1143763avodire
aware86420023a_ware
awhile1257793awhile
awhirl1264673awhirl
axile126020513a_xile
axite125218253a_xite
axlike17388853axlike
azide155617163a_zide
azine146721413a_zine
azure14911483a_zure
baddie104114033baddi_e
balmier113811513balmier
barmie103816393barmi_e
barmier114313043barmier
bemired123410633bemired
bemires113212833bemires
caddice13327733caddice
caddie104316453caddi_e
cadmic1338983cadmi_c
cadmium1446113cadmium
cadre85419023cad__re
camise103319633camise
cammie124615293cammi_e
carmine112918483carmine
casimire1244773casimire
cire65836373__cire
coadmired1542743coadmired
coadmires1444033coadmires
dacite91115883dacite
dairy97016303_dairy
damage10410773damage
damar84117733damar_
damars93814993damars
dame77140313dam__e
dammer114317933dammer
damner95213433damner
damper114117753damper
dare55848863_d_are
dative10311813dative
daymare1375633daymare
deice84320033_deice
demirep1236213demirep
demise94618323demise
demure9311533demure
dere56845903_d_ere
desire7415303desire
dice75841893_d_ice
die46759653_d_i_e
dike95935763_d_ike
dime76237643_d_ime
dimer85625603_dimer
dine55555333_d_ine
direr64927073_d_irer
dirge75117073_d_irge
dirk96326833_d_irk
dirl57430023_d_irl
dirt55550383_d_irt
dite55547553_d_ite
dive85634773_d_ive
domine92918253domine
dore56353303_d_ore
drier64423963_drier
drive95318003_drive
dure56341813_d_ure
dwine95616143_dwine
edgier8469733edgier
edile64819493ed_ile
elmier839813elmier
emigre937053_emigre
emir65918703_emir_
emirs76116163_emirs
empire1039323empire
entire61617703entire
ermine8416923ermine
expire1538023expire
faddier1237783faddier
fadlike15318483fadlike
famine114318193famine
fire76245593__fire
fomite113314073fomite
fumier11310903fumier
gamier93617933gamier
gamine94620153gamine
gammier123711193gammier
glaire74411293glaire
hammier143510653hammier
hardwire1544623hardwire
harmine122816193harmine
haywire1644743haywire
hire75538963__hire
hombre13309303hombre
homie104622533homi_e
homier116416993homier
imide85716893_imide
imine75821063_imine
immure1036033immure
ire36943173___ire
jadeite1546403jadeite
jammier18408023jammier
jasmine1636643jasmine
laddie83713173laddi_e
lamiae84817453lamiae
limier83518723limier
lire47845293__lire
madeira1045103madeira
madre85720173mad__re
malmier113611953malmier
mamie95826003mami_e
mammie94313783mammi_e
mare64759333__mare
marmite112413993marmite
mere67244443__mere
mice87442233__mice
mike105535293__mike
mile66352573__mile
mime85736403__mime
mine67256173__mine
mir57046773__mir_
mired85729223__mired
mires75640883__mires
mirex146816623__mirex
miri66730373__miri
mirk106729503__mirk
mirs66940573__mirs
miry96326753__miry
mise66043583__mise
mite66249413__mite
mitre75522423__mitre
moire71017323_moire
more67154523__more
mure65941333__mure
nadir61012973nad_ir_
nadirs7109003nad_irs
ombre94111803_ombre
padre86018163pad__re
palmier113312173palmier
pismire1135353pismire
pumice1238223pumice
quagmire2042383quagmire
quire144917133_quire
ramie75027823rami_e
rammier112811023rammier
refire95419473refire
rehire95415863rehire
remise84221953remise
retire64927013retire
rewire95421413rewire
rimfire1243793rimfire
rimier83916273rimier
saltire73113033saltire
samite83020603samite
satire63218003satire
sempre102710093sempre
shire84727133_shire
simile83115633simile
sire46150413__sire
smile74823923_smile
smirk116612753_smirk
smite75224873_smite
sombre10729473sombre
somite84519373somite
spire75828693_spire
squire155912463squire
tammie104212693tammi_e
timbre10328633timbre
tire46143353__tire
umpire1047893umpire
unadmired1343863unadmired
unmitre936993unmitre
vampire14296673vampire
venire93513693venire
waddie114013323waddi_e
wire75839813__wire
zaire14311993_zaire

Search took 6 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.403443402.0
2DLD Change Limit1127163784.97022679.3
3Display Results3783780.1263000.0
 (SQL Overall)1786913785.49932495.2
 
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.