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

458 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
acarid9501706(None) 
acari75020281acari_
acarids105312241acarids
acaroid103512301acaroid
acrid86920101ac_rid
ascarid103910711ascarid
acacia10311352acacia
acaridan1165232acaridan
acarine9316002acarine
acarus8312192acarus
acid77533392ac__id
acred87126352ac_red
afraid1049712afraid
agamid103710672agamid
agaric93513622agaric
aramid93315602aramid
arid57642712__arid
ascared10399522ascared
ascarids11438502ascarids
ascaris93613322ascaris
award97118042awar_d
caid77837532_ca_id
caird85717232_caird
canid85526342_canid
card710245872_car_d
cared86050092_cared
caried94528692_caried
scared95227292scared
sparid94016932sparid
aahed917816443a_ahed
aalii5316123a_alii
aargh96314083a_argh
abaci94718843abaci_
abased96514993abased
abasia8712953abasia
abated95918453abated
abatis84317933abatis
abfarad1344223abfarad
aboard9312613aboar_d
abri65522213a_bri_
abris75722603a_bris
acacias11510393acacias
acajou1595233acajou
acapnia1145913acapnia
acaricide1444413acaricide
acaridans1254033acaridans
acarines10314343acarines
accord1178843accord
accrue1035823accrue
accrued1233823accrued
aced79540883ac__ed
acedia9310393acedia
acerb9312763acer_b
acerbic1335643acerbic
acetamid1344783acetamid
acetic10314503acetic
acetin8314693acetin
ached119227833ac_hed
acidic113612133acidic
acids87121003ac__ids
acidy117214893ac__idy
acini75718983acini_
acinic104713543acinic
acmatic13311693acmatic
acmic11312333ac_mic
acned87520663ac_ned
acold86214923ac_old
acorn75616623acor_n
acorned10238263acorned
acorns85013013acorns
acquit17610323acquit
acrasia9310033acrasia
acrasin9311223acrasin
acre67330773ac_r_e
acres76327763ac_res
acrider1038623ac_rider
acridly13396533ac_ridly
acted88521733ac_ted
actin74922553ac_tin
adagio847663adagio
adored84714233adored
aerie54634603a_erie
aeried74221863a_eried
afar76720783afar__
afars85716513afar_s
afeard1058263afear_d
afeared1176833afeared
afrit8323173a_frit
again65218113aga_in
agamic113110543agamic
agamids11317003agamids
agar58726413agar__
agarics10319943agarics
agars66120643agar_s
agatoid948603agatoid
agria65517143a_gria
aid49269073__a_id
aired66032923a_ired
ajar116217703ajar__
aland65526413ala_nd
alanin6317273alanin
alar46340073alar__
alarm76621423alar_m
alarmed1037733alarmed
alarms85913053alarms
alarum85411983alarum
alary86123443alar_y
alated75625143alated
alcaic1039983alca_ic
alcaide1088453alca_ide
alcid85817963a_lcid
aldrin7311243aldrin
algid75415573a_lgid
algoid83011463algoid
amain74922883ama_in
amarna839793amarna
amazed18519303amazed
ambari103012153ambari_
ambaris113112123ambaris
ambroid1238863ambroid
amid77036333__amid
anarch11310393anarch
android9311503android
aneared8512743aneared
aneroid8313983aneroid
angaria8311553angaria
antacid10311203antacid
anuria6313103anuria
anuric8812093anuric
apart74330673apar_t
aphid115515393a_phid
aporia8315863aporia
aquaria1638033aquaria
arabic10312733arabic
aramids102810503aramids
araneid8310793araneid
arcaded1178973arcaded
arcadia1039703arcadia
aria46245423__aria
aril45843023__aril
aroid65428333a_roid
arris56824683a_rris
asarum84610913asarum
ascarides12346953ascarides
astride8311973astride
atavic11189293atavic
ataxia13179593ataxia
ataxic15169203ataxic
atria56022333a_tria
atrip75315743a_trip
attrit6315743attrit
auric74521723a_uric
auris55331523a_uris
avail8313883ava_il
avarice1238033avarice
avid88325963__avid
avoid95516673a_void
await85524493awa_it
awaked14579203awaked
awarded1236223awarded
awards107113453awards
aware86420023awar_e
bard75648863_bar_d
bared85144483_bared
baric96125693_baric
bayard124411663bayar_d
beard86024963bear_d
bedrid1039943bedrid
blared95018243blared
board85523003boar_d
braid85822263bra_id
cabin94820933_cabin
cactoid12311023cactoid
cad67456363_ca__d
cadi75732173_cadi_
cadis84428493_cadis
caged95426363_caged
caids85226423_ca_ids
cain65643913_ca_in
cairds96411513_cairds
cairn75717513_cairn
caked126128623_caked
calcaria1249523calcaria
calif104929093_calif
calix145317343_calix
canard9314763canar_d
candid104517853candid
caned85838093_caned
canids95118133_canids
caped104931803_caped
capiz18514563_capiz
capric12411793capric
capris10415073capris
capsid11312413capsid
car59165563_car__
carabid12311333carabid
carat75048793_carat
carb85143163_car_b
carbide126112493_carbide
carbo94923843_carbo
carbs96031463_carbs
carded105424903_carded
cardia9916373_cardia
cardio9915673_cardio
cards85137933_cards
care66968373_car_e
carer74942333_carer
cares77369183_cares
caret75360563_caret
carex144822293_carex
cargo85322073_cargo
caribe103416743_caribe
caries85147623_caries
carina84325323_carina
caring95137993_caring
cark105539273_car_k
carked134024823_carked
carks115534213_carks
carl65144783_car_l
carle74535703_carle
carlin84421823_carlin
carls77037423_carls
carn66245433_car_n
carnie84421093_carnie
carns75937563_carns
carny105822923_carny
carob95325223_carob
carol75128613_carol
carom95025563_carom
carotid102014813_carotid
carp85139813_car_p
carped115923763_carped
carpi94319393_carpi
carps96932253_carps
carr65434703_car_r
carried103717153carried
carrs75730853_carrs
carry105823783_carry
cars67364763_car_s
carse74934333_carse
cart66570343_car_t
carte75940423_carte
carted98631443_carted
carts78946293_carts
carve106227753_carve
carved124320853_carved
cased86032413_cased
cauld85318443_cauld
caved116227563_caved
cavie104621593_cavie
cavil103816493_cavil
cawed116627063_cawed
cebid104314063_cebid
cered85227443_cered
ceria75125353_ceria
ceric94023093_ceric
cervid1239323_cervid
chard116124743char_d
chared125423693chared
chid106626403_c_hid
clerid9312413clerid
cord76740923_cor_d
cored85044223_cored
coria75828303_coria
corvid12310473_corvid
cred76530883_c_red
crib86323573_c_rib
cried84624283_c_ried
cris66233433_c_ris
crit65743713_c_rit
crud75219613_c_rud
cupid103212783_cupid
curd77634983_cur_d
cured85932133_cured
curia74523763_curia
curie74533033_curie
curio74221203_curio
cyanid123912033cyanid
dared75935013_dared
daric85623113_daric
dearie73319813dearie
diacid10310633diacid
eared65139503_eared
ecarte84313503ecarte
echard1249223echar_d
elapid939543elapid
factoid1338693factoid
farad95720673_farad
fard85639063_far_d
fared95842343_fared
feared106320433feared
flared105317603flared
florid10311453florid
gadid85517373_gadid
geared85317743geared
glared84715193glared
gravid113710973gravid
grid65829613__grid
guard74415543guar_d
hadarim13117423hadarim
halid94424973_halid
hard85443503_har_d
hared95742183_hared
hazard1938403hazar_d
heard95222753hear_d
hoard94918313hoar_d
horrid10311553horrid
hybrid15237813hybrid
hydrid14248963hydrid
irid55927163__irid
jerid132316423_jerid
jerrid14259143jerrid
laari54415713laari_
lacertid1146383lacertid
laid56439143_la_id
laird65417793_laird
lard56742003_lar_d
lari45839153_lari_
laris54737463_laris
liard65418593liar_d
lurid64618973_lurid
lyard95113213lyar_d
maid75537633_ma_id
malaria9313693malaria
maria75032883_maria
mazard1838763mazar_d
murid84520583_murid
nacred95212493nac_red
nard56634453_nar_d
naric76824173_naric
naris55735293_naris
navaid1037643nava_id
neared75119803neared
nitrid72812233nitrid
oared65030653_oared
ocarina948023ocarina
ochred12328003ochred
ochroid1357903ochroid
ozalid1696673ozalid
pagurid11105433pagurid
paid75737483_pa_id
pard76441323_par_d
pardi85723953_pardi
pared86946763_pared
paris75145943_paris
pavid115717003_pavid
placard1236783placar_d
placid114012543placid
plaid85118303pla_id
putrid9311163putrid
qaid146023843_qa_id
rabid84520773_rabid
raid55243073_ra_id
ranid66429333_ranid
rapid86422033_rapid
rared65738323_rared
reared75930013reared
rid46754623___rid
roared75015393roared
sacraria1047393sacraria
sacred94917103sac_red
safari91110223safari_
safaried1236253safaried
safaris101110663safaris
said55742113_sa_id
salaried9311023salaried
sapid84720933_sapid
sard55344243_sar_d
sari45444043_sari_
sarin55239253_sarin
saris54544953_saris
sarod65325873_sarod
satyrid1137233satyrid
savarin10310003savarin
sayid95516723_sayid
scad75725763sca__d
scald84818123sca_ld
scaled94822443scaled
scaped115519553scaped
scar66434203scar__
scarab10310063scarab
scarce104013633scarce
scare75334463scar_e
scarer84524603scarer
scares85033003scares
scarey115016983scarey
scarf105427143scar_f
scarfed134711183scarfed
scarfs114714683scarfs
scarier94017873scarier
scarify1537443scarify
scarily12311703scarily
scaring103421973scaring
scarp95724103scar_p
scarped124314393scarped
scarph13429603scarph
scarps104718603scarps
scarred104512633scarred
scarry116311183scarry
scars75433533scar_s
scart76139773scar_t
scarted104816123scarted
scarts85321493scarts
scary105222593scar_y
schrik15206703schrik
schrod1247883schrod
sciurid1044923sciurid
scored94621133scored
scoria8513483scoria
scried95817303sc_ried
scrim95419723sc_rim
scrip96619193sc_rip
scrod85115063sc_rod
seared75232843seared
shaird10288703shaird
shard96125963shar_d
shared105829063shared
sharia93116723sharia
sharif122917113sharif
sialid7314933sialid
snared74824553snared
soared74324293soared
spared95427483spared
sparids103512123sparids
sparoid102311533sparoid
staid66722073sta_id
stared75429873stared
subarid10310653subarid
sward94221463swar_d
tabanid1047323tabanid
tabard9313333tabar_d
tabid84418253_tabid
talaria7412503talaria
tamari8313383tamari_
tamarin9311893tamarin
tamarind1147013tamarind
tamaris9413573tamaris
tared69340053_tared
teared75722153teared
torrid7311853torrid
uakari1046863uakari_
uakaris1146633uakaris
urari54619963urari_
uraris63817273uraris
vacated1349353vacated
valid94618383_valid
vapid115614283_vapid
varia85824203_varia
varied104817863_varied
varix154313503_varix
vaward13498723vawar_d
virid94116043_virid
ward86542253_war_d
wared96339873_wared
wearied112911803wearied
yaird96111913_yaird
yard85633253_yar_d
zoaria1548373zoaria

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.1401276364.3
2DLD Change Limit1127164585.01622471.3
3Display Results4584580.1403271.4
 (SQL Overall)1786914585.29633740.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.