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

362 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
admires103866(None) 
admire949931admire_
admired1135701admired
admirer1035521admirer
admirers1134711admirers
admixes1765961admixes
adheres11310162adheres
adjures1536232adjures
admiral1046362admiral
admirals1144352admirals
admits9411412admi_ts
admixed1833732admixed
adores74420722ad_ores
advices13136932advices
advises11138972advises
amices105018012a_mices
amides95722662a_mides
amies76837692a_mi_es
amines84727982a_mines
amirs75924922a_mir_s
ammines11312672ammines
armies85123692armi_es
armoires1057622armoires
armures9510272armures
aspires9612042aspires
attires72312952attires
bemires113212832bemires
coadmires1444032coadmires
mires75640882__mires
abides94719893a_bides
abjures1636523abjures
acmes96020653acm__es
acquires1945403acquires
acres76327763a__cres
actives12311523actives
adages8412953ad_ages
adamsites1243513adamsites
addaxes1634573addaxes
adders84315703adder_s
addicts1176013addicts
addles84216603ad_dles
address956103ad_dress
addrest958633ad_drest
adduces1185763adduces
adenines9310193adenines
adhere10310333adhere_
adhered1239233adhered
adherer1137573adherer
adherers1296923adherers
adieu6417423ad_i_eu
adieus739633ad_ieus
adios65822863ad_i_os
adits66523713ad_i_ts
adjure1435843adjure_
adjured1634883adjured
adjurer1534823adjurer
adjurers1634373adjurers
admass957143adm_ass
admasses1135413admasses
admen84516183adm__en
admiring1236133admiring
admit8319493admi__t
admitted1234763admitted
admittee1145133admittee
admittees1243273admittees
admitter1135113admitter
admitters1244553admitters
admix1557733admi__x
admixt1637333admi_xt
admixtures2052193admixtures
adobes94411533ad_obes
adonises92611433adonises
adore65723673ad_ore_
adored84714243ad_ored
adorer74713453ad_orer
adorers84411733ad_orers
adorns74212613ad_orns
adsorbs1044713adsorbs
adverbs13254273adverbs
adverse1145953adverse
adverts11308513adverts
advice12107883advice_
advise10139223advise_
advised12136043advised
advisee11147153advisee
advisees12154133advisees
adviser11135783adviser
advisers12135003advisers
adzes155913803ad__zes
aediles83413903aediles
aegises8311373aegises
aeries64737783aeri_es
affaires1444303affaires
affines1339483affines
affirms1534383affirms
affixes2035503affixes
afire86215913a_fire_
aggies83515513aggi_es
agnizes17328843agnizes
aides65336603a__ides
aimers84621913aimer_s
aired66032923a__ired
airer54927893a__irer
airers64922313a__irers
airest63825263a__irest
airns55521033a__irns
airs46447423a__ir_s
airts55626343a__irts
albites9313203albites
alines65735223a_lines
alkies104518093alki_es
alkines114415733alkines
allies63827673alli_es
allures72913113allures
almes75126543alm__es
almners9399563almners
almuces11316823almuces
almudes10418263almudes
alpines94016193alpines
alsikes1137263alsikes
alumines10411683alumines
amazes175613473a_mazes
ambers104519583a_mbers
ambles105121863a_mbles
ambries111614553a_mbries
ameers84015573a_meers
amerces1149853a_merces
amias75831473a_mi_as
amice96122873a_mice_
amicus103810003a_micus
amide86128483a_mide_
amids85627513a_mi_ds
amie66339853a_mi_e_
amigas95912173a_migas
amigos94511213a_migos
amine75835383a_mine_
amins75534323a_mi_ns
amir65129753a_mir__
amirates101114793a_mirates
amis66445323a_mi__s
amiss75823073a_mi_ss
amities9317383a_mities
ammine10314493ammine_
amoles84122193a_moles
amperes11313983amperes
amuses85117943a_muses
animes84719593a_nimes
anises64826693a_nises
anomies93316993anomi_es
antired82316193antired
antres65021003a_ntres
aperies9423203aperies
aphides134711203aphides
apices104916263a_pices
aplites9314933aplites
apomixes1934853apomixes
apres75426403a__pres
apsides103911303apsides
arbores94016033arbores
ares45871023a___res
arises65233803a_rises
armers85520273armer_s
armiger1036253armiger
armigers1135703armigers
armings103811503armings
armoire938133armoire_
armored102610473armored
armorer9259913armorer
armorers10288973armorers
armories10313653armories
armors85017813armor_s
armrest9310163arm_rest
armure8710133armure_
arrises71617583arrises
arrives101311513arrives
arsines73518813arsines
ascites9312603ascites
asides75118873a_sides
aspire8612123aspire_
aspired1068173aspired
aspirer967903aspirer
aspirers1066493aspirers
aspises9611643aspises
assizes1638453assizes
assures7611403assures
atomies93918363atomi_es
atomises103514403atomises
atomizes192711433atomizes
attire62412383attire_
attired8238913attired
audiles83112613audiles
augites8312183augites
aures55137093a__ures
avodires1244123avodires
axises134413993a_xises
axites134913833a_xites
azides165113803a_zides
azines155517073a_zines
azures15510183a_zures
baddies114017873baddi_es
bemire103312803bemire_
bemired123410633bemired
bemixes18338653bemixes
caddices14297853caddices
caddies113718383caddi_es
caddises12329353caddises
cadmiums1544403cadmiums
cadres94017933cad__res
camises114218463camises
cammies134016483cammi_es
carmines123617873carmines
casimires1344693casimires
cimices13279803cimices
cires74932913__cires
coadmire1344043coadmire_
coadmired1542743coadmired
dacites101114593dacites
daddies103414943daddi_es
dairies84217733_dairies
daises74318983_daises
damages11511283damages
damars93815003damar_s
dames85435853dam__es
dammers123214273dammers
damners104112113damners
dampers123915693dampers
dares66146703_d_ares
datives11310073datives
davies105020513davi_es
daymares1445333daymares
deices94119373_deices
demies94825803demi_es
demirep1236213demirep
demireps1343993demireps
demises103719563demises
desires81316133desires
dices86434243_d_ices
dies55653523_d_i_es
dikes105831333_d_ikes
dimers94321093_dimers
dimes85833043_d_imes
dines66449153_d_ines
dire56644143_d_ire_
direr64927073_d_irer
direst75024243_d_irest
dirges84915103_d_irges
dirks105619523_d_irks
dirls64720503_d_irls
dirts66824463_d_irts
dites66339153_d_ites
dives95832403_d_ives
domines102918973domines
dories75232363_dories
driers74516733_driers
dries64733673_dri_es
drives105117113_drives
dures65635923_d_ures
dwines105013103_dwines
eddies83313163eddi_es
ediles74016983ed_iles
emigres1037673_emigres
emirs76116163_emir_s
empires1139853empires
entires71517783entires
ermines9416673ermines
expires1638683expires
famines123216263famines
fires85740753__fires
fomites123613203fomites
gamines103618463gamines
glaires84010143glaires
hardwires1644643hardwires
harmines132715143harmines
haywires1744043haywires
hires86134343__hires
hombres14369873hombres
homies114524723homi_es
homines123518643homines
imides94515343_imides
imines84918353_imines
immies102412443immi_es
immixes1835073immixes
immures1136713immures
ires45639283___ires
jadeites1645823jadeites
jammies183611293jammi_es
jasmines1736623jasmines
laddies93715053laddi_es
ladies75124883lad_i_es
lemures938793lemures
limites92915453limites
madeiras1144773madeiras
madres93718183mad__res
mamies104626243mami_es
mammies104314763mammi_es
mares76457633__mares
marmites122212793marmites
meres75143573__meres
mikes115129893__mikes
miles74645073__miles
mimes95732023__mimes
mines75651953__mines
mire66748233__mire_
mired85729223__mired
mirex146816623__mirex
mirks115122143__mirks
mirs66940573__mir_s
mises74740563__mises
mites75141803__mites
mitres83922073__mitres
mixes147224403__mixes
moires8915633_moires
mores76249643__mores
mures75937223__mures
nadirs7109003nad_ir_s
ombres103911143_ombres
paddies113715723paddi_es
padres95016983pad__res
panmixes1934913panmixes
pismires1235883pismires
pumices1338273pumices
quagmires2142303quagmires
quires154015753_quires
radices102314263rad_ices
radixes15259343rad_ixes
ramies84630463rami_es
refires104820313refires
rehires105016113rehires
remiges103015473remiges
remises93423483remises
remixes164313873remixes
retires74726213retires
rewires104717113rewires
rimfires1344203rimfires
saltires83112433saltires
samites93118713samites
satires72617573satires
semises93916553semises
shires95225573_shires
similes92915233similes
sires55945373__sires
smiles84522293_smiles
smirks124910123_smirks
smites83921923_smites
somites94219123somites
spires84628113_spires
squires163812843squires
tamises92715973tamises
tammies113814683tammi_es
timbres11249353timbres
tires55437493__tires
umpires1137813umpires
unadmired1343863unadmired
unmitres1036863unmitres
unmixes16197753unmixes
vampires15226033vampires
venires103012453venires
vires84529683__vires
waddies124214753waddi_es
wadies105121203wad_i_es
wires86034913__wires
zaires1539703_zaires

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.390458182.1
2DLD Change Limit1340273626.32621186.7
3Display Results3623620.1262873.0
 (SQL Overall)1786913626.84226116.8
 
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.