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
acids87121012a_cids
ahis76135382a_hi_s
aids57846372a__ids
alcids94812292alcids
amids85627522a_mids
apods86316342ap_ods
apsides103911302apsides
apsis75718292apsi_s
aroids75118222aroids
avoids104410202avoids
capsids1239332capsids
ephods1238362ephods
phis95724902_phi_s
raphias123511082raphias
raphide13138072raphide
raphides14188392raphides
raphis114014322raphi_s
rapids94913892rap_ids
whids125413992_whids
aahed917816443aahed_
aahing1019015763aahing
aahs716428563aah__s
aaliis6312903aaliis
abhors11410623abhors
abide86223723a_bide
abides94719893a_bides
ablins8316193ablins
abris75722613abri_s
acarids105312243acarids
ached119227833ached_
aches106132293ach_es
achier113914263achier
achiest12315193achiest
aching126521973aching
acid77533403a_cid_
acidy117214903a_cidy
acrid86920103acrid_
actins86321103actins
adds67622463a__dds
adios65822863a_dios
adits66523713a_dits
admits9411413admits
ads49755743a___ds
aegis6316783aegi_s
aeries64737783aeries
afrits9311913afrits
agamids11317013agamids
aggies83515513aggies
aghas97014873agh_as
agios65919863a_gios
agrias74315403agrias
ahed89536253a_hed_
ahi68040233a_hi__
ahimsa1134783a_himsa
ahing98928353a_hing
aholds10469483aholds
ahs68644823a_h__s
aid49269093a__id_
aide56045013a__ide
aides65336613a__ides
aikido1135483aikido
aikidos1253883aikidos
ails45654723a__ils
aims67738193a__ims
ains46158893a__ins
airs46447433a__irs
ais39083583a__i_s
aits46355543a__its
alands75418373alands
alcid85817973alcid_
algid75415583algid_
algins74816433algins
alias55834603a_lias
alifs86121263a_lifs
alkies104518093alkies
alkyds14404363alkyds
allies63827673allies
allods73615083allods
almuds9378773almuds
aloins65022203aloins
alphas1139513alph_as
alphyls15113953alphyls
ambits103713423ambits
amends94713283amends
amias75831473a_mias
amid77036363a_mid_
amide86128493a_mide
amides95722663a_mides
amido85720993a_mido
amidst94913233a_midst
amies76837693a_mies
amins75534323a_mins
amirs75924923a_mirs
amis66445323a_mi_s
amiss75823073a_miss
amnios84912523amnios
amphipods1952673amphipods
ands57833623a__nds
anils56326723a_nils
anis45746473a_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
apish105116643ap_ish
aplite8316393aplite
aplites9314933aplites
apneas83211383apneas
apod78123183ap_od_
aporias9315163aporias
apos65433823ap__os
appals104812943appals
appels104312793appels
appends1236393appends
apples104315763apples
applies11311223applies
apps86319693ap__ps
apres75426403ap_res
aprons8316993aprons
apses76823913ap_ses
apsidal1046703apsidal
aramids102810513aramids
archils12510533archils
argils75213623argils
arhats9312983arhats
arias55438043a_rias
arid57642723a_rid_
arils58732203a_rils
armies85123693armies
aroid65428343aroid_
arris56824683arri_s
arshins10312573arshins
arsis55722423arsi_s
asdics9439863asdics
ashed97829773ashed_
ashes86230613ash_es
ashier94714833ashier
ashiest10313963ashiest
ashing107824093ashing
aside65122093a_side
asides75118873a_sides
aspics104211563aspics
aspis74618143aspi_s
athirst1037873athirst
attics84413283attics
audads8167103audads
audios72312283audios
audits72814113audits
auris55331533auri_s
auxins13129813auxins
avails939693avails
avid88325973a_vid_
avoid95516683avoid_
awaits96411953awaits
awards107113453awards
awhile1257793awhile
awhirl1264673awhirl
axils127217503a_xils
axis116127913a_xi_s
ayins85321613a_yins
azide155617173a_zide
azides165113803a_zides
azido155411553a_zido
behinds1335283behinds
bids75838463__bids
bovids1287973bovids
braids95015693braids
caids85226433_caids
candids113812693candids
canids95118133canids
caphs124515373caph__s
capias10318353cap_ias
caplins113515993caplins
capris10415083capri_s
capsid11312423capsid_
cebids11439183cebids
cepheids1644243cepheids
chads116122233_chads
chias104625523_chias
chics123920943_chics
chid106626413_chid_
chide115321023_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
fids87034753__fids
fluids10349423fluids
gadids95611823gadids
gadoids1036873gadoids
ganoids939333ganoids
geoids8369843geoids
ghis85020163_ghi_s
gids65933753__gids
graphics1645653graphics
grids75321403_grids
guids75516163_guids
halids104016133halids
haloids113012553haloids
hapkido1743143hapkido
hapkidos1842713hapkidos
haploids1437363haploids
hid76248393__hid_
hide85134653__hide
hides95129433__hides
hies74842843__hies
hims95230983__hims
hinds96721483__hinds
hins76448003__hins
hips96433713__hips
his66359513__hi_s
hiss75629223__hiss
hits75545143__hits
hods87239873__hods
hyoids1377673hyoids
ids47535483___ids
imids86015153_imids
iodids83711153iodids
irids66417783_irids
jassids1586143jassids
jehads1735833jehads
jerids142810943jerids
jihads1734483jihads
kaphs144911503kaph__s
khis117017993_khi_s
kids96029653__kids
lapides103012043lap_ides
lapins84520683lap_ins
lapis76223153lap_i_s
lashins103915153lashins
lathis95516173lathi_s
lids56336473__lids
lipids94310923lipids
lipoids1038233lipoids
loids66220713_loids
maids86327153_maids
mantids103113623mantids
mashies12318253mashies
masjids17175403masjids
mids76541803__mids
murids93212193murids
mysids1246563mysids
napkins1336673napkins
nappies114613403nappies
navaids1134803navaids
nihils937573nihils
ohias84415573_ohias
ootids71110353ootids
ophite11410563ophite
ophites12310103ophites
opioids1036523opioids
opsins8411713opsins
optics102810183optics
orchids1377213orchids
ovoids10456923ovoids
oxids13128973_oxids
padis86227143padi_s
pads76742963_p_ads
pagods105310193pagods
paid75737493_paid_
paiks114719853_paiks
pails75833063_pails
pains75138283_pains
pairs75325833_pairs
panics103815363panics
papains11312373papains
paphian1437453paphian
paphians1545593paphians
pappies103214833pappies
pards85634333_pards
paries84742523paries
paris75145943pari_s
patins87528783patins
patios85221793patios
pavid115717003pavid_
pavins114919663pavins
pavis106422733pavi_s
peds75835253_p_eds
peins76128063_peins
pends85527193_pends
peptids12239333peptids
phi86524203_phi__
phial10313203_phial
phials1158873_phials
phiz186718843_phi_z
phizes20389133_phizes
phons105221143_phons
phots105418503_phots
phuts104613503_phuts
pias66542563_p_ias
pics85633923_p_ics
pies66949613_p_ies
pigs76634233_p_igs
pins65558463_p_ins
pips85837143_p_ips
pis56362043_p_i_s
piss65033343_p_iss
pits66348753_p_its
plaids94312443plaids
plies74526513_plies
plods85719293_plods
pods76540163_p_ods
poinds93511143_poinds
pois66539043_poi_s
ponds85323403_ponds
poods85124753_poods
pride84724743_pride
prides94324183_prides
pries74339533_pries
prigs85219703_prigs
prims95425933_prims
priss74623893_priss
prods85523553_prods
psis68120343_psi_s
puds75630523_p_uds
pyins105815863_pyins
qaids156116323_qaids
quids154917473_quids
rachides141511223rachides
rachis114017653rachi_s
raids65827523_raids
ranids75118703ranids
raphes115117453raph_es
raphia113511263raphi_a
rapid86422033rap_id_
rawhide14134973rawhide
rawhides15145543rawhides
rebids94015533rebids
resids74219153resids
rids56539563__rids
sahibs1137083sahibs
saids65328863_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
skids104615343_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_
vids85627553__vids
voids95414683_voids
whid115418883_whid_
whigs125612643_whigs
whims134515333_whims
whins114922333_whins
whips134917083_whips
whirs115218093_whirs
whits115923823_whits
xiphoids2144193xiphoids
yids85224973__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.406440125.6
2DLD Change Limit1127164486.17018268.4
3Display Results4484480.1562871.8
 (SQL Overall)1786914486.73226543.5
 
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.