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

448 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
aphids12511084(None) 
aphid115515391aphid_
aphides134711201aphides
aphis105917131aphi_s
acids87121002a_cids
ahis76135382a_hi_s
aids57846362a__ids
alcids94812292alcids
amids85627512a_mids
apods86316342ap_ods
apsides103911302apsides
apsis75718292apsi_s
aroids75118222aroids
avoids104410202avoids
capsids1239332capsids
ephods1238362ephods
phis95724902_phi_s
raphias123511082raphias
raphide13138072raphide
raphides14188392raphides
raphis114014322raphi_s
rapids94913892rap_ids
whids125413982_whids
aahed917816443aahed_
aahing1019015763aahing
aahs716428563aah__s
aaliis6312903aaliis
abhors11410623abhors
abide86223713a_bide
abides94719893a_bides
ablins8316193ablins
abris75722603abri_s
acarids105312243acarids
ached119227833ached_
aches106132293ach_es
achier113914263achier
achiest12315193achiest
aching126521973aching
acid77533393a_cid_
acidy117214893a_cidy
acrid86920103acrid_
actins86321103actins
adds67622453a__dds
adios65822863a_dios
adits66523713a_dits
admits9411413admits
ads49755733a___ds
aegis6316783aegi_s
aeries64737783aeries
afrits9311903afrits
agamids11317013agamids
aggies83515513aggies
aghas97014873agh_as
agios65919863a_gios
agrias74315393agrias
ahed89536253a_hed_
ahi68040233a_hi__
ahimsa1134783a_himsa
ahing98928353a_hing
aholds10469483aholds
ahs68644823a_h__s
aid49269083a__id_
aide56045003a__ide
aides65336603a__ides
aikido1135473aikido
aikidos1253883aikidos
ails45654713a__ils
aims67738183a__ims
ains46158883a__ins
airs46447423a__irs
ais39083573a__i_s
aits46355533a__its
alands75418373alands
alcid85817973alcid_
algid75415583algid_
algins74816433algins
alias55834603a_lias
alifs86121263a_lifs
alkies104518093alkies
alkyds14404363alkyds
allies63827673allies
allods73615083allods
almuds9378773almuds
aloins65022203aloins
alphas1139513alph_as
alphyls15113953alphyls
ambits103713413ambits
amends94713283amends
amias75831473a_mias
amid77036353a_mid_
amide86128483a_mide
amides95722663a_mides
amido85720983a_mido
amidst94913233a_midst
amies76837693a_mies
amins75534323a_mins
amirs75924923a_mirs
amis66445323a_mi_s
amiss75823073a_miss
amnios84912523amnios
amphipods1952673amphipods
ands57833613a__nds
anils56326723a_nils
anis45746463a_ni_s
antics84621453antics
antis55033313anti_s
anvils9219713anvils
apathies1339013apathies
aped78538153ap_ed_
aperies9423203aperies
apers76629133ap_ers
apes66047433ap__es
apexes1539133apexes
aphagias14237353aphagias
aphasias132710443aphasias
aphasics15257243aphasics
apheses12610703apheses
aphesis12610513aphesis
aphidian1445533aphidian
aphidians1544053aphidians
aphonias132611143aphonias
aphonics15259523aphonics
aphtha1444483aphtha
apian75018333ap_ian
apices104916263apices
aping87327233ap_ing
apish105116633ap_ish
aplite8316393aplite
aplites9314933aplites
apneas83211383apneas
apod78123183ap_od_
aporias9315153aporias
apos65433823ap__os
appals104812943appals
appels104312793appels
appends1236393appends
apples104315763apples
applies11311223applies
apps86319693ap__ps
apres75426403ap_res
aprons8316993aprons
apses76823913ap_ses
apsidal1046703apsidal
aramids102810513aramids
archils12510533archils
argils75213623argils
arhats9312973arhats
arias55438023a_rias
arid57642713a_rid_
arils58732203a_rils
armies85123693armies
aroid65428343aroid_
arris56824683arri_s
arshins10312573arshins
arsis55722423arsi_s
asdics9439863asdics
ashed97829773ashed_
ashes86230613ash_es
ashier94714833ashier
ashiest10313963ashiest
ashing107824093ashing
aside65122083a_side
asides75118873a_sides
aspics104211563aspics
aspis74618143aspi_s
athirst1037873athirst
attics84413283attics
audads8167103audads
audios72312283audios
audits72814113audits
auris55331533auri_s
auxins13129813auxins
avails939693avails
avid88325963a_vid_
avoid95516683avoid_
awaits96411953awaits
awards107113453awards
awhile1257793awhile
awhirl1264673awhirl
axils127217503a_xils
axis116127913a_xi_s
ayins85321613a_yins
azide155617163a_zide
azides165113803a_zides
azido155411543a_zido
behinds1335283behinds
bids75838453__bids
bovids1287973bovids
braids95015693braids
caids85226423_caids
candids113812693candids
canids95118133canids
caphs124515373caph__s
capias10318353cap_ias
caplins113515993caplins
capris10415083capri_s
capsid11312413capsid_
cebids11439173cebids
cepheids1644243cepheids
chads116122233_chads
chias104625523_chias
chics123920943_chics
chid106626403_chid_
chide115321013_chide
chides124620473_chides
chins105631463_chins
chips125721253_chips
chis95933313_chi_s
chits105424573_chits
cupids11369193cupids
daphnes13327683daphnes
daphnias1444683daphnias
dashis104414393dashi_s
dauphins1444523dauphins
diapsids1244753diapsids
droids84712583droids
druids8368093druids
elapids1036503elap_ids
ephahs1435503ephahs
ephas10311543eph_as
ephod1139123ephod_
ephors11311403ephors
epics95014283ep_ics
equids16439143equids
ethics11169283ethics
felids103111623felids
fids87034743__fids
fluids10349423fluids
gadids95611823gadids
gadoids1036873gadoids
ganoids939333ganoids
geoids8369843geoids
ghis85020163_ghi_s
gids65933743__gids
graphics1645653graphics
grids75321393_grids
guids75516153_guids
halids104016133halids
haloids113012553haloids
hapkido1743143hapkido
hapkidos1842713hapkidos
haploids1437363haploids
hid76248383__hid_
hide85134643__hide
hides95129423__hides
hies74842833__hies
hims95230973__hims
hinds96721473__hinds
hins76447993__hins
hips96433703__hips
his66359503__hi_s
hiss75629213__hiss
hits75545133__hits
hods87239863__hods
hyoids1377673hyoids
ids47535473___ids
imids86015143_imids
iodids83711153iodids
irids66417773_irids
jassids1586143jassids
jehads1735833jehads
jerids142810943jerids
jihads1734483jihads
kaphs144911503kaph__s
khis117017983_khi_s
kids96029643__kids
lapides103012043lap_ides
lapins84520683lap_ins
lapis76223153lap_i_s
lashins103915153lashins
lathis95516173lathi_s
lids56336463__lids
lipids94310923lipids
lipoids1038233lipoids
loids66220703_loids
maids86327143_maids
mantids103113623mantids
mashies12318253mashies
masjids17175403masjids
mids76541793__mids
murids93212193murids
mysids1246563mysids
napkins1336673napkins
nappies114613403nappies
navaids1134803navaids
nihils937573nihils
ohias84415573_ohias
ootids71110353ootids
ophite11410563ophite
ophites12310103ophites
opioids1036523opioids
opsins8411713opsins
optics102810183optics
orchids1377213orchids
ovoids10456923ovoids
oxids13128963_oxids
padis86227143padi_s
pads76742953_p_ads
pagods105310193pagods
paid75737483_paid_
paiks114719853_paiks
pails75833063_pails
pains75138283_pains
pairs75325833_pairs
panics103815363panics
papains11312363papains
paphian1437453paphian
paphians1545593paphians
pappies103214833pappies
pards85634333_pards
paries84742513paries
paris75145943pari_s
patins87528783patins
patios85221783patios
pavid115717003pavid_
pavins114919663pavins
pavis106422733pavi_s
peds75835243_p_eds
peins76128063_peins
pends85527193_pends
peptids12239323peptids
phi86524203_phi__
phial10313203_phial
phials1158873_phials
phiz186718843_phi_z
phizes20389133_phizes
phons105221143_phons
phots105418503_phots
phuts104613503_phuts
pias66542553_p_ias
pics85633913_p_ics
pies66949603_p_ies
pigs76634223_p_igs
pins65558453_p_ins
pips85837133_p_ips
pis56362033_p_i_s
piss65033333_p_iss
pits66348743_p_its
plaids94312443plaids
plies74526513_plies
plods85719293_plods
pods76540153_p_ods
poinds93511143_poinds
pois66539043_poi_s
ponds85323403_ponds
poods85124753_poods
pride84724733_pride
prides94324183_prides
pries74339533_pries
prigs85219703_prigs
prims95425933_prims
priss74623893_priss
prods85523553_prods
psis68120343_psi_s
puds75630513_p_uds
pyins105815863_pyins
qaids156116313_qaids
quids154917463_quids
rachides141511223rachides
rachis114017653rachi_s
raids65827513_raids
ranids75118703ranids
raphes115117453raph_es
raphia113511263raphi_a
rapid86422033rap_id_
rawhide14134973rawhide
rawhides15145543rawhides
rebids94015533rebids
resids74219153resids
rids56539553__rids
sahibs1137083sahibs
saids65328853_saids
saiyids11174893saiyids
salpids1038193salpids
sapheads1466083sapheads
sapid84720933sap_id_
sapphics1743423sapphics
sayids104310973sayids
sayyids14193833sayyids
scaphoids1744603scaphoids
shads95124483_shads
sheds96122703_sheds
shies86136553_shies
shims104422553_shims
shins85131043_shins
ships105123773_ships
shits84731173_shits
shivs115018803_shivs
skids104615333_skids
sloids73712693sloids
solids74116403solids
sophies12314623sophies
spahis11310383spahi_s
spails84817823spails
spaits85017473spaits
sparids103512123sparids
speeds94316053speeds
speils84116223speils
speirs85013233speirs
speiss84311643speiss
spends94714473spends
sphinx1866203sphinx
spics94123243sp_ics
spies76037623sp_ies
spiks114117473sp_iks
spins75327983sp_ins
spits74429553sp_its
spivs105114243sp_ivs
splits85416413splits
spoils84614533spoils
sprigs94814773sprigs
sprits85122533sprits
spuds85113673sp_uds
squids16409803squids
sulphids1444373sulphids
sylphids1743953sylphids
syrphids1744243syrphids
tapirs84113173tap_irs
tapis75028863tap_i_s
teiids736693teiids
thins85826333_thins
thirds10438603_thirds
this76027383_thi_s
thuds95110133_thuds
typhoids1745493typhoids
upbinds12234813upbinds
upends9438763upends
upgirds11103073upgirds
uphill11106173uphill
uphills1295233uphills
upholds13135243upholds
upside9289803upside
upsides10319633upsides
upwinds13224223upwinds
ursids737823ursids
vapid115614283vap_id_
vids85627543__vids
voids95414673_voids
whid115418873_whid_
whigs125612643_whigs
whims134515333_whims
whins114922333_whins
whips134917083_whips
whirs115218093_whirs
whits115923823_whits
xiphoids2144193xiphoids
yids85224963__yids
zooids1637093zooids

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 Filter1786911127160.390458182.1
2DLD Change Limit1127164485.97018880.4
3Display Results4484480.1403200.0
 (SQL Overall)1786914486.50027490.9
 
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.