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
acaroid10351230(None) 
acarid95017061acar_id
acari75020282acar_i_
acarids105312242acar_ids
acrid86920102ac_r_id
agatoid948602agatoid
ambroid1238862ambroid
android9311502android
aneroid8313982aneroid
aroid65428332__aroid
ascarid103910712ascar_id
carotid102014812_carotid
ochroid1357902ochroid
sparoid102311532sparoid
abroad9310943a_broad
acacia10311353aca_cia
acajou1595233acajo_u
acajous1666483acajous
acanthoid1553923acanthoid
acapnia1145913acapnia
acarbose1244683acarbose
acaricide1444413acaricide
acaridan1165233acar_idan
acarine9316003acarine
acarpous1245313acarpous
acarus8312193acar_us
accord1178843ac_cord
accrued1233823accrued
acerbic1335643acerbic
acerola947823acerola
acerose9310893acerose
acerous9513333acerous
achromic1747613achromic
acid77533393ac___id
acold86214923ac__old
acorned10238263acorned
acrasia9310033acrasia
acrasin9311223acrasin
acred87126353ac_r_ed
acromia1139963ac_romia
acronic112814693ac_ronic
across8312643ac_ross
acrotic112515533ac_rotic
actinoid1148003actinoid
acyloin1247453acyloin
adenoid959243adenoid
adroit7518783a_droit
afraid1049713a_fraid
agamid103710673aga_mid
agaric93513623agar_ic
agarose838653agarose
alarmed1037733alarmed
algoid83011463a_lgoid
alkaloid1345283alkaloid
amarone9311193amarone
amberoid1346413amberoid
ambroids1346473ambroids
ameboid1277223ameboid
amyloid1348533amyloid
anconoid1146453anconoid
androids1047743androids
aneroids9310183aneroids
anthoid11313303anthoid
aramid93315603ara_mid
araneid8310793araneid
araroba945763araroba
arid57642713__ar_id
aroids75118223__aroids
ascared10399523ascar_ed
ascarids11438503ascar_ids
ascaris93613323ascar_is
asteroid9511173asteroid
autacoid1146243autacoid
avoid95516673__avoid
award97118043awar__d
awarded1236223awarded
bacteroid1456243bacteroid
cactoid12311023cactoid
caid77837533_ca__id
cancroid1346523cancroid
candid104517853_candid
canid85526343_ca_nid
canoed94618953_canoed
capsid11312413_capsid
carabid12311333_carabid
carbide126112493_carbide
card710245873_car__d
carded105424903_carded
cardia9916373_cardia
cardio9915673_cardio
cardioid1247433_cardioid
cared86050093_car_ed
caried94528693_caried
carked134024823_carked
carlin84421823_carlin
carload1039783_carload
carnie84421093_carnie
carob95325223_caro_b
carobs104818103_carobs
caroch13911763_caroch
carol75128613_caro_l
caroled103717683_caroled
caroli85918233_caroli
carols85124983_carols
carom95025563_caro_m
caromed123713623_caromed
caroms105619573_caroms
carotids11229933_carotids
carotin92216713_carotin
carped115923763_carped
carpi94319393_carpi_
carried103717153_carried
carted98631443_carted
carved124320853_carved
ceboid11310653_ceboid
cervid1239323_cervid
choroid13311793choroid
cirsoid1038123_cirsoid
conoid9818883_conoid
cormoid12310403_cormoid
corvid12310473_corvid
crowd115815623_c_rowd
cuboid1139503_cuboid
cymoid1459463_cymoid
droid74218533__droid
emeroid101511173emeroid
factoid1338693fac_toid
fibroid1337243fibroid
gabbroid1452763gabbroid
gadoid9310443_gadoid
ganoid8314433_ganoid
haloid104317753_haloid
hyaloid1439063hyaloid
hydroid1539703hydroid
labroid1038823labroid
lacertid1146383lacertid
lianoid837523lianoid
macaroni1246523macaroni
macaronic1545243macaronic
macaronis1346563macaronis
macaroon1246343macaroon
manatoid1148813manatoid
negroid9108883negroid
neuroid81110303neuroid
oceloid1037963oceloid
octroi837363octroi_
octrois938333octrois
paranoid11311133paranoid
parotid102915503_parotid
placoid1239763placoid
racemoid1344813racemoid
sarcoid10310453_sarcoid
sarod65325873_saro_d
scaphoid1646053scaphoid
scaraboid1443743scaraboid
scared95227293scar_ed
scarfed134711183scarfed
scarped124314393scarped
scarred104512633scarred
scarted104816123scarted
schrod1247883schro_d
sciuroid1144403sciuroid
scleroid1147203scleroid
scrod85115063sc_ro_d
sialoid8310953sialoid
sparid94016933spar_id
sparoids11218713sparoids
spiroid10219823spiroid
sporoid102310723sporoid
steroid81314853steroid
theroid11313393theroid
thyroid1438243thyroid
toroid7416013_toroid
viroid10411523_viroid
zebroid1936463zebroid

Search took 10 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.220812231.8
2DLD Change Limit1340271759.09314739.6
3Display Results1751750.0463804.3
 (SQL Overall)1786911759.35919093.0
 
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.