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

175 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
acaroid10351231(None) 
acarid95017071acar_id
acari75020282acar_i_
acarids105312242acar_ids
acrid86920102ac_r_id
agatoid948622agatoid
ambroid1238882ambroid
android9311512android
aneroid8314012aneroid
aroid65428342__aroid
ascarid103910722ascar_id
carotid102014832_carotid
ochroid1357902ochroid
sparoid102311542sparoid
abroad9310943a_broad
acacia10311353aca_cia
acajou1595233acajo_u
acajous1666483acajous
acanthoid1553933acanthoid
acapnia1145913acapnia
acarbose1244683acarbose
acaricide1444413acaricide
acaridan1165233acar_idan
acarine9316003acarine
acarpous1245313acarpous
acarus8312193acar_us
accord1178843ac_cord
accrued1233823accrued
acerbic1335653acerbic
acerola947833acerola
acerose9310903acerose
acerous9513343acerous
achromic1747613achromic
acid77533393ac___id
acold86214933ac__old
acorned10238283acorned
acrasia9310043acrasia
acrasin9311223acrasin
acred87126353ac_r_ed
acromia1139973ac_romia
acronic112814693ac_ronic
across8312643ac_ross
acrotic112515543ac_rotic
actinoid1148023actinoid
acyloin1247463acyloin
adenoid959253adenoid
adroit7518793a_droit
afraid1049723a_fraid
agamid103710693aga_mid
agaric93513643agar_ic
agarose838673agarose
alarmed1037743alarmed
algoid83011473a_lgoid
alkaloid1345293alkaloid
amarone9311203amarone
amberoid1346433amberoid
ambroids1346503ambroids
ameboid1277233ameboid
amyloid1348543amyloid
anconoid1146463anconoid
androids1047753androids
aneroids9310203aneroids
anthoid11313313anthoid
aramid93315613ara_mid
araneid8310803araneid
araroba945763araroba
arid57642713__ar_id
aroids75118223__aroids
ascared10399523ascar_ed
ascarids11438503ascar_ids
ascaris93613323ascar_is
asteroid9511213asteroid
autacoid1146253autacoid
avoid95516683__avoid
award97118043awar__d
awarded1236223awarded
bacteroid1456273bacteroid
cactoid12311033cactoid
caid77837533_ca__id
cancroid1346523cancroid
candid104517853_candid
canid85526343_ca_nid
canoed94618963_canoed
capsid11312423_capsid
carabid12311333_carabid
carbide126112493_carbide
card710245873_car__d
carded105424903_carded
cardia9916383_cardia
cardio9915673_cardio
cardioid1247453_cardioid
cared86050093_car_ed
caried94528693_caried
carked134024823_carked
carlin84421823_carlin
carload1039783_carload
carnie84421093_carnie
carob95325223_caro_b
carobs104818103_carobs
caroch13911763_caroch
carol75128613_caro_l
caroled103717693_caroled
caroli85918233_caroli
carols85124983_carols
carom95025563_caro_m
caromed123713623_caromed
caroms105619573_caroms
carotids11229953_carotids
carotin92216733_carotin
carped115923763_carped
carpi94319393_carpi_
carried103717153_carried
carted98631443_carted
carved124320853_carved
ceboid11310653_ceboid
cervid1239323_cervid
choroid13311803choroid
cirsoid1038123_cirsoid
conoid9818883_conoid
cormoid12310403_cormoid
corvid12310473_corvid
crowd115815623_c_rowd
cuboid1139503_cuboid
cymoid1459473_cymoid
droid74218543__droid
emeroid101511183emeroid
factoid1338693fac_toid
fibroid1337253fibroid
gabbroid1452763gabbroid
gadoid9310463_gadoid
ganoid8314443_ganoid
haloid104317763_haloid
hyaloid1439073hyaloid
hydroid1539713hydroid
labroid1038823labroid
lacertid1146393lacertid
lianoid837533lianoid
macaroni1246523macaroni
macaronic1545243macaronic
macaronis1346563macaronis
macaroon1246343macaroon
manatoid1148823manatoid
negroid9108903negroid
neuroid81110313neuroid
oceloid1037973oceloid
octroi837363octroi_
octrois938343octrois
paranoid11311143paranoid
parotid102915513_parotid
placoid1239773placoid
racemoid1344813racemoid
sarcoid10310453_sarcoid
sarod65325873_saro_d
scaphoid1646053scaphoid
scaraboid1443753scaraboid
scared95227293scar_ed
scarfed134711183scarfed
scarped124314403scarped
scarred104512633scarred
scarted104816123scarted
schrod1247883schro_d
sciuroid1144403sciuroid
scleroid1147213scleroid
scrod85115073sc_ro_d
sialoid8310963sialoid
sparid94016933spar_id
sparoids11218713sparoids
spiroid10219823spiroid
sporoid102310733sporoid
steroid81314873steroid
theroid11313403theroid
thyroid1438253thyroid
toroid7416013_toroid
viroid10411523_viroid
zebroid1936473zebroid

Search took 8 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 Limit1340271757.22018563.3
3Display Results1751750.0632777.8
 (SQL Overall)1786911757.67323288.3
 
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.